Excel: Convert Second to Minute

You have number of second and want to convert into minute format. Use this function.

Replace you value in this function:
=INT(value/60) & ":" & TEXT(INT(MOD(value,60)), "00")

For example:
=INT(H4/60) & ":" & TEXT(INT(MOD(H4,60)), "00")

Note that 'H4' is cell in Excel.

The value will be:
603 Seconds will be shown as 10:03

Comments

Popular posts from this blog

Microsoft Visio: How to set default font

LINE: Change the contact name

Microsoft Word: Make picture background to be transparent