close

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
------------------------------------------------------------------------
bagoxc's Profile: www.excelforum.com/member.php...oamp;userid=30084
View this thread: www.excelforum.com/showthread...hreadid=498132
I found it.......[h]:mm:ss

Thanks anyway!

Chuck--
bagoxc
------------------------------------------------------------------------
bagoxc's Profile: www.excelforum.com/member.php...oamp;userid=30084
View this thread: www.excelforum.com/showthread...hreadid=498132ahaaa thats what that is..... time formats are frustrating arent they!
--
paul
remove nospam for email addy!
quot;bagoxcquot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()