# 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

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