AlexOrrow

Calculating End time from Duration

Discussion created by AlexOrrow on Oct 15, 2016
Latest reply on Oct 17, 2016 by AlexOrrow

Hi,

 

Novice question apologies!

 

I'd like to add a duration in hours and mins to a start time field with the result being an end time see examples. I understand that 1 hour equals 3600s but I cannot figure out a simple and clean way to make a calculation that will return the right time for a give duration in hours and mins?

 

Is this possible and can anyone please provide some pointers?

 

 

Thank you,

Alex

 

e.g.1

Start Time: 0900

Duration: 1hr 30mins

End Time: 10:30

 

e.g.2

Start Time: 0900

Duration: 30mins

End Time: 0930

Outcomes