Converting time (raw) into ss:mm

  • Thread starter Derrick Schmitt
  • Start date
D

Derrick Schmitt

I have a report on which I recieve time information in the following format:
4.87, where this number represents 4 minutes and 87/100th of a minute.

I am looking for a way to convert this to mm:ss in excel.

So far I'm thinking I have to convert the 4.87 to seconds
I've tried then taking that number =A1/(60*60*24)

But I am not gettting the correct times.

Does anyone have a solution or some suggestions to try?
 

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

Display minutes more than 60 2
Time format conversion 7
convert time 2
Formating seconds into mm:ss 4
Excel Convert Datetime Stamp to HH and MM Worked 7
Excel Need Countifs Formula Help 0
Time Conversion issue 5
How can I convert or format an elapsed time to show mm:ss 4

Top