Search in pcbugz

Custom Search

Wednesday, September 11, 2013

How to calculate time in Excel

Checking into your subordinate's total spent time of work is beneficial for you in checking if they are misbehaving or not, or you would like to know when you have encountered overtime, then this will help you a lot. The calculations provided here is set to only one day, not between days.


BLACK ARROW:
1. Select the cell, right click,
    Format Cells
2. @ Normal Tab, select Custom
    Select h:mm AM/PM
    OK
RED OBLONG/BOX:
Select h:mm

CALCULATIONS:
 E3 = D3 - C3
 F3 = E3 - F1
 
To end: count then share blessings like Web traffic exchange to others

No comments:

Post a Comment

What do you think?