Converting decimal to seconds

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 

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

Decimal/Percentage to Whole Number 4
Access Convert a decimal time to hours and minutes 2
Excel How To Convert Decimal To Inches 2
convert decimal figure to minutes and seconds 3
i want to convert decimals into time format 3
convert time in decimals to minutes 2
convert minutes to seconds 2
How to convert number in to time lenght, minutes and seconds? 3

Back
Top