Timed Task

[keith2435]

It is 2:12 am and a task last 67 minutes. Is there a formula that will add the 67 to the 2:12 that will show 3:19 am?

[Pepe Le Mokko]

=A1+B1/1440 ( A1 start time - task duration in B1) Format as h:mm

[keith2435]

Thanks for the formula. It worked wonderfully!!!!!!!!! If you don't mind, why 1440

[Pepe Le Mokko]

Excel sees a day as 1, thus an hour as 1/24 and a minute as 1/24*60.
So, to go from the decimal value of 67 to the sexagesimal value you have to divide by 1440 ( if it were seconds you would have to divide by 24*60*60)
If you want to understand this better look up daddylonleg's posts on this forum. His solutions are incredibly elegant