![]() To convert seconds entered in cells to minutes and seconds, divide the seconds by the total number of seconds in a day (60 multiplied by 60 multiplied by 24) and then apply the time custom number format of mm:ss (minutes and seconds). Converting seconds to minutes and seconds Codes include h for hour, m for minute and s for seconds. ![]() There are several time formats in this dialog box. In the General Area, enter mm:ss or click it in the list.īelow is the Format Cells dialog box with the minutes and seconds custom format:.Click Custom in the category on the left. ![]()
0 Comments
Leave a Reply. |