Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

Display decimal in minutes and seconds in MS Excel

No comments
Tuesday sickness. Another reason to be sick is the person calling on my local line. But of course, I don't have a choice but to answer it.

foxtrot

Hello this is foxtrot. How may I help you?


Alfred

Hi. I have problem on my worksheet. I need to submit it today. I hope you can give a solution. I divided two numbers to get the minutes but the result was decimal. I like it to be displayed in Minutes and seconds.



If you have the same problem, here is a solution. You can display a decimal in minutes and seconds by following these steps:

1. Divide the decimal value by 1440.
2. Right+click the cell that has the result the click format.
3. On the format dialog, choose custom then "mm:ss".

No comments :

Post a Comment