I need to convert the number 6.87 minutes to minutes and seconds so it reads 6.52. I know the formula to convert the decimal portion (.87) to seconds is 87*60/100=52 so it will show 6.52 (6 minutes and 52 seconds).
Thanks for any help.
Kenny
I need to convert the number 6.87 minutes to minutes and seconds so it reads 6.52. I know the formula to convert the decimal portion (.87) to seconds is 87*60/100=52 so it will show 6.52 (6 minutes and 52 seconds).
Thanks for any help.
Kenny
Try this,
=INT(A1)+(A1-INT(A1))*60/100
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thanks, that is exactly what I was looking for.
Glad it helped - thanks for the feedback
Or =A1/1440 and format as [m]:ss
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks