5 Replies Latest reply on Oct 17, 2016 1:33 AM by AlexOrrow

    Calculating End time from Duration

    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