Bash,

No idea why it isn't working for you, nor what the AddIn does, just
noticed it in testing.

I re-checked and do have some cells formatted for [hhh]:mm:ss and some
as [h]:mm:ss, both work as expected, with improper hours.
I didn't use the 'Convert', was just reading up on that when I fond the
reference to the ToolPak

That is in Excel 2003 SP1.



Bash Wrote:[color=blue]
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.




--
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