View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bagoxc
 
Posts: n/a
Default Second question converting seconds to hours


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: http://www.excelforum.com/member.php...o&userid=30084
View this thread: http://www.excelforum.com/showthread...hreadid=498132