Need excel formula to calc time i.e.08:29:29am-23:21:32pm=9:07:57

G

Guest

I need to determine the amount of time a process took. It begain at
23:21:32pm and finished at 8:29:29am. The total time = 9:07:57 (9hrs 7min
57sec). I need a formula to calculate the total time. The formual I tried
=text(b10-b9,"h:mm:ss") and that produced #VALUE!. I changed to the 1904
date system under tools/options/calculation and that produced -14:52:03. If
I could convert that negative to a positive from 2400 hrs then I would have
the correct answer. Any insight would be greatly appreciated.... please and
thank you. :) I'm using excel 2003 microsoft office professional edition.
 
B

Bob Phillips

=MOD(B10-B9,1)

and format as time

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Bernard Liengme

The problem is that B10 is less than B9, so use
=(B2-B1)+(B1>B2)
The second term as 1 (24 hours) to the result is the start time is greater
than the end time
best wishes
 
Top