Second question converting seconds to hours

[bagoxc]

Thank you everyone for your help with my earlier issue. This might just be a formatting problem, but I can't seem to figure this out. I'm horrible working with time issues in excel.

I have a raw number of 676953 in seconds and I need a formula to convert a number like this to 188:02:33. When I try formating with hh:mm:ss it will only go to 24 hours and roll over.

Does this make sense? Am I missing something?

Thanks in advance.

Chuck

[bagoxc]

I found it.......[h]:mm:ss

Thanks anyway!

Chuck

[paul]

ahaaa thats what that is..... time formats are frustrating arent they!
--
paul
remove nospam for email addy!



"bagoxc" wrote:

>
> I found it.......[h]:mm:ss
>
> Thanks anyway!
>
> Chuck
>
>
> --
> bagoxc
> ------------------------------------------------------------------------
> bagoxc's Profile: http://www.excelforum.com/member.php...o&userid=30084
> View this thread: http://www.excelforum.com/showthread...hreadid=498132
>
>