MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using time in calculation


Posted by Gregg Muret on September 20, 2001 11:28 AM

I'm trying to add a time duration to an initial 'start' time to calculate the 'end' or final time. I have an initial (time 'in') military time (11:32:45) and need to add a duration to it (7) which equals seconds to acheive a final time 'out'. I cannot format the (7) into seconds or add it straight into the initial time. Please help me, it's driving me crazy. What if the duration is 132-seconds?


Posted by IML on September 20, 2001 11:37 AM

Try
=+A1+(7/86400)
where A1 is your start time and 86,400 is a constant. This converts your seconds into the fraction of a day excel recognizes.
Make sure format the cell as time.

Good luck


Posted by Aladin Akyurek on September 20, 2001 11:38 AM

=A1+B1/86400

where A1 houses the initial time, B1 the number of seconds you want to add to A1.

Aladin

Posted by Barrie Davidson on September 20, 2001 11:39 AM

One second equals 0.0000115740740740741. Multiply this figure by the number of seconds you want to add and then add the total to your start time.

Hope this is what you need.

Regards,
BarrieBarrie Davidson

Posted by Aladin Akyurek on September 20, 2001 11:45 AM

A web script...

or a Java applet that could spawn a pop up window to show the response(s) posted while one is struggling to produce one's own.
Alas.

Cheers.

Aladin

=======