Converting date into date and hours

I have half hourly energy data and need to convert the date into hourly format. At present the date is dd/mm/yyyy and hour is 0.5,1.0,1.5,... I want to get it as yyyy-mm-dd HH:MM:SS Any idea how to do it??

[James Tursa]

Please be more specific. What is the exact format of your input data (the date and hour data)? Character string array and double array? Cell arrays? Or ...? And what do you want for the result ... a cell array of character strings? Or ...?

Answer 1

[Peter Perkins]

Use datetimes and durations:

>> t0 = datetime('today','Format','yyyy-MM-dd HH:mm:ss')
t0 = 
  datetime
   2017-09-21 00:00:00
>> t = t0 + hours(0:.5:3)'
t = 
  7×1 datetime array
   2017-09-21 00:00:00
   2017-09-21 00:30:00
   2017-09-21 01:00:00
   2017-09-21 01:30:00
   2017-09-21 02:00:00
   2017-09-21 02:30:00
   2017-09-21 03:00:00