![]() ![]() To make the displayed times more meaningful to your users, you can supplement the time unites with the corresponding words, for example: ABC DescriptionĪpplied to our sample data (Total time 50:40 in the screenshot above), these custom time formats will produce the following results: ABC The following screenshot shows the "over 24 hours" custom time format in action:īelow are a few other custom formats that can be used to display time intervals exceeding the length of the standard time units. This will open the Format Cells dialog box.On the Number tab, under Category, select Custom, and type one of the following time formats in the Type box:Over 24 hours: :mm:ss or :mmOver 60 minutes: :ssOver 60 seconds: The detailed steps follow below:Select the cell(s) you want to format.Right click the selected cells and then click Format Cells, or press Ctrl + 1. To show a time interval of more than 24 hours, 60 minutes, or 60 seconds, apply a custom time format where a corresponding time unit code is enclosed in square brackets, like, , or. How to display time over 24 hours, 60 minutes, 60 seconds The task is a lot easier than it may sound, and you will know the solution in a moment. When subtracting or adding time in Excel, you may sometimes want to display the results as the total number of hours, minutes or seconds. The article shows a few tips to calculate and display times that are greater than 24 hours, 60 minutes, 60 seconds.īạn đang xem: A day is not 60*60*24 seconds long
0 Comments
Leave a Reply. |