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:
* * *
Sunday, April 13, 2014
How to create new *.PST file
Outlook 2010 enables to keep Contacts/Calendar/Notes folders
in an external file.
The file format is filename.PST.
To create a new PTS file, on the Home TAB click New Items, More
Items, Outlook Data files . . .
* * *
Subscribe to:
Posts (Atom)