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.