Excel Time Formula Question

  bremner 19:46 21 May 2004

Any Excel guru's out there?

I have been asked by a colleague if there is an Excel formula that can automatically change a number of seconds to a time.

ie cell A1 has the number 145 can a formula be entered into cell B1 that converts this to 0:02:25 meaning 0 hrs 2 mins 25 seconds.


  SANTOS7 20:19 21 May 2004

To transform minutes in hours and minutes (125 becoming 2:05), use this simple formula (the format of the destination cell must be hh:mm):
click here more useful info here

  bremner 20:21 21 May 2004

Tyhanks will look over the link, I do need to be able to do hh:mm:ss

  pc moron 23:24 21 May 2004

Will this do what you want?


86400 is the number of seconds in 24 hours and the brackets around hh will allow a time greater then 24 hours to be shown.

  Eric10 23:44 21 May 2004

Adding to my postings. pc moron, I'd just come up with a way of doing this using the TEXT function also but it was about 10 times as long as your formula.

  bremner 07:55 22 May 2004

Have given that a try and it does exactly what I want.

Thank you very much.

  pj123 13:30 22 May 2004

Also added to mine.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

There’s more to Finnish artist Tove Jansson than creating the Moomins

iPhone X news: Release date, price, new features & specs

Comment regarder la Coupe du monde de rugby à XIII en direct ?