Second question converting seconds to hours

  • Thread starter Thread starter bagoxc
  • Start date Start date
B

bagoxc

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

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

Does this make sense? Am I missing something?

Thanks in advance.

Chuc
 
ahaaa thats what that is..... time formats are frustrating arent they!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert dd:hh:mm:ss to seconds 5
Calculating Hours, Minutes and Seconds 6
Converting Seconds to Hours, Minutes, Seconds 3
Access Convert a decimal time to hours and minutes 2
Excel Calculating Phone bill per second 6
years-months-days-hours 5
Change seconds in hours, minutes and seconds 2
Convert time to all seconds 2

Back
Top