On Fri, 4 Nov 2005 18:58:01 -0800, "Bash"
wrote:

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.

You'll have to ignore what you see in the formula bar.

Format the cell as [h]:mm:ss.

Any mathematical operations will work OK.

So far as Excel is concerned, 53:12:49 is stored as 2.21723380 and is
equivalent to 1/2/1900 5:12:49 AM


--ron