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