Excel Formula [Thread 30921]

I want to put a formula in excel attendance sheet to calculate late time of employees if they r late than official time, for example
my office time start at 8:00Am I want to calculate the late timings of employees if they r reaching 10 minutes late or 1 hour then in 1 column.
it would come automatically.
plz help to put formula for this..
Many thanks

In excel sheet, make four columns as under:
a) 1st column : Date : 1st Jun, 2nd Jun .....
b) 2nd column : starting time, say 8:00 (write in this format only)
c) 3rd column : Entry time of employees, say 10:10 (write in this format only)
d) 4th column : Late by ___ minutes (comes automatically by applying the formula : (c3-b3) * 1440
If you want any more clarification, do get back to me on [Login to view]
Rgds,
Chetan

Can anybody can tell me that what kind of excel knowledge is required in HR generalist profile..:icon9:

Please help me out asap,because all the time the requirement is for EXCEL KNOWLEDGE...:sad: