Converting decimal to seconds

D

Dave

Hello:

I have a number say 11.75 (minutes) and I want to convert it to mins:sec
(which would make it 11min 45 sec. How can I do this? Any help would be
appreciated.
 
B

BenjieLop

Dave said:
Hello:

I have a number say 11.75 (minutes) and I want to convert it t
mins:sec
(which would make it 11min 45 sec. How can I do this? Any help woul
be
appreciated.
Click to expand...

If your number is in Cell A1, enter this formula in Cell B1

=A1/(24*60)

So, if Cell A1 contains 11.75, B1 (custom formatted at mm:ss) wil
yield 11:45.

Now, if you want B1 to say "11 min 45 sec" then your formula is

=floor(A1,1)&" min"&" "&round((A1-floor(A1,1))*60,0)&" sec"

Hope this will help you
 
M

Myrna Larson

Times are stored as a fraction of a day. To convert the decimal number 11.75
minutes to a time, you must divide by the number of minutes in a day, which is
1440. Then format the result cell with a time format.
 
Top