John,

The formulas that David and Arvi gave you are correct, and do work. So in order
to help you, we need to know what happened when 'it did not work.' What did
happen? What result was displayed? Also, tell us how you type in the start and
finish times (specifically, what characters do you type?).

--
Regards,
Fred


"John L" wrote in message
...

Thanks David Billigmeier and Arvi Laanemets,

I must be missing something. I applyed both formulas and it did not
work.
Let me explain what I'm trying to do.
I'm a Fire/Police Captain. When we are called out on a call i must log
the time of dispatch and the time we are finished with the call. The
times will vary from PM and AM. Sometimes the calls start in the PM and
finish in the AM. I need to log how much _time_ was used at the scene.
What I'm looking for is the have it show X Hours and X mins.

Example: Time at call: X Hours and X mins

Thanks John L


--
John L
------------------------------------------------------------------------
John L's Profile:
http://www.excelforum.com/member.php...o&userid=34774
View this thread: http://www.excelforum.com/showthread...hreadid=545361