How to add a date/time with a real number (decimal hours) to create a new date/time

I have a column with start date in date /time format and I would like to add a cum duration (decimal hour) to that start date to know the exact date/time (hh:mm) of a particular task.  The source of my data doesn't provide me with that.  I think if I somehow convert the real number representing decimal hour to a time format hh:mm then it would shorten my steps.  So far I've used the expressions and three intermediate calculated columns:  

DateAdd("hour",[Cum Duration],[dttmstart])    `adds the hour

right(String([Cum Duration]),3)     `converts to string and captures everything after decimal 

Cast ([Minutes] as Real) * 60 `converts to real minutes 

DateAdd("minute",[Minutes (Real)],[task time (hour)])    'Adds minutes to the previously added hour task time column

This seems like a lot of steps to accomplish what I am doing.  Any shortcuts appreciated.

 

Attachments

AttachmentSize
Image icon 2018-02-28_11-40-21.jpg134 KB

(1) Answer

Login