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