Providing the highest quality
Microsoft Office user training to
New England companies.
Specializing in training proprietary
software programs for small to
midsized companies for their clients.
Contact: Sherri Buhr @ (508) 587-5708 or
email @
Sherri.Buhr@slbTraining.com
Excel Tip
To calculate an
employee's
working hours :

Enter the following into
a cell: =D4-C4
+IF(C4D4,1)

The number 1 in the IF
formula equals
24 when working with
time.

For example, in row 6,
the calculation is
6.00 - 20.31+ 24.00 =
9.29.
Improve
Productivity
Increase Computer Knowledge