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:
* * *
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:
* * *
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:
* * *
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment