Wednesday, December 10, 2014

Summing work hours in Excel

Excel cell with the regular Time format hh:mm counts or sums up to 24:00 hours therefore to sum and display amount of hours greater than 24 hours, the format of the cell must be customized.

In order to sum the total work hours accumulated after several days, the format of the cell containing the total sum of the hours, should be changed to the Custom format type [hh]:mm.

Formatting cell G7 to [hh]:mm in 3 clicks:



* * *

No comments:

Post a Comment