Multiplying hours and dollars

In order to obtain the right results of Dollar X Hours calculations in cell C12, the total hours of cell C10 must be multiplied by 24 to compensate on the way that Excel is handling cells with time format. Thus C12 should have the formula C10*24*C11.

* * *

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:

* * *

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 . . .

* * *