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

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.

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

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



"doodlebug" wrote in message
...
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.

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

The problem is that B10 is less than B9, so use
=(B2-B1)+(B1B2)
The second term as 1 (24 hours) to the result is the start time is greater
than the end time
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"doodlebug" wrote in message
...
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.

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

......................... And format the cell for time
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
The problem is that B10 is less than B9, so use
=(B2-B1)+(B1B2)
The second term as 1 (24 hours) to the result is the start time is greater
than the end time
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"doodlebug" wrote in message
...
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.

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

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

"Bob Phillips" wrote:

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



"doodlebug" wrote in message
...
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.

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

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

--
Regards,
Tom Ogilvy


"doodlebug" wrote:

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

"Bob Phillips" wrote:

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



"doodlebug" wrote in message
...
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.