Use this format instead, Bash:
[h]:mm:ss
************
Anne Troy
www.OfficeArticles.com
"Bash" wrote in message
...
I work for a call center where in a process I keep the track of time
duration
of calls. I want to write a time durations in the formatt of hh:mm:ss.
However if I write say 53:12:49 (where it should mean 53 hours, 12 minutes
and 49 seconds) excel takes it as 1/2/1900 5:12:49 AM. Even if I go to
formatt and change the data type to hh:mm:ss it remains the same.