Excel Time Formula Question

  bremner 19:46 21 May 04
Locked

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.

Thanks

  SANTOS7 20:19 21 May 04

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):
=A1/1440
click here more useful info here

  bremner 20:21 21 May 04

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

  pc moron 23:24 21 May 04

Will this do what you want?

=TEXT(A1/86400,"[hh]:mm:ss")

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 04

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 04

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

Thank you very much.

  pj123 13:30 22 May 04

Also added to mine.

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…