Neaten up your time sheets with this custom cell format.In Microsoft Excel, you can format a cell containing the sum of amounts of time that exceed 24 hours with the number format “[h]:mm:ss”; Microsoft Excel automatically adds times beyond 24 hours and formats them correctly.
This format works correctly with times that exceed 24 hours.
Note: Range is either the defined name of a range that contains the times or the cell reference of the range that contains your times (for example, A1:A4). The values in the range must be in the “h:mm” or “hh:mm” format.
Leave a Reply
You must be logged in to post a comment.