![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |