Bryan,

I added the Analysis ToolPak, changed the format to [h]:mm:ss and then
closed and opened the excel. Its not happening, I still see it in '1/2/1900
5:12:49 AM' formatt in the formula bar . I did not quite understand how
'Convert' function should be used is this. May be that's where I am going
wrong.

Bash

"Bryan Hessey" wrote:


Bash,

I tried Anne's suggestion and, at first, it didn't work, Excel did not
want to keep the improper format.

Then I read the 'Convert' function and loaded the Add-in Analysis
ToolPak (Tools - Add-ins..) and closed / re-opened the Workbook.

Now it shows the 53 hours in Anne's [h]:mm:ss format.



Bash Wrote:
I tried it. Its not helping.

"Anne Troy" wrote:

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.





--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=482408