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

[doodlebug]

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.

 

[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)

 

[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

 

[Bernard Liengme]

......................... And format the cell for time

 

[doodlebug]

Thank you so much. That worked nicely! What is MOD?

 

[Tom Ogilvy]

It is the modulus function. It is a worksheet function documented in help
for Excel.