Arvi Laanemets, Thanks very much, It worked.
I entered what you said. Then i formatted the cell to CUSTOM/h:mm.
Now when i enter the time of dispatched and finished i get " Hour:mm
".
I can use this to let me know that the call lasted for (example) 3 hr
and 32 mins.
I'll have one more question. But first i have to see how to write it up
so it can be understood.
Thanks again and have a wonderful holiday weekend.
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