Please help me to calculate the late hours of the employee.
example:
A1= TIME IN
A2= TIME OUT (LUNCH)
A3= TIME IN (LUNCH)
A4= TIME OUT
A5= LATE HOURS
Thanks!
Please help me to calculate the late hours of the employee.
example:
A1= TIME IN
A2= TIME OUT (LUNCH)
A3= TIME IN (LUNCH)
A4= TIME OUT
A5= LATE HOURS
Thanks!
Daily Time Sheet 2.xls
this is the sample sir
What do you mean when you say "Late hours"?
Which is the expected result in that column?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
For example, my start time in job is 8:00AM then I came at exactly 8:01AM then I'm 1 minute late
Hi,
I have attached my version of how i would calculate it.
Regards,
M
Sir! I forgot, if Monday the office starting hour is 8:30AM then if tuesday-friday the starting time is 9:00am then i will compute the remaining time.
for example:
i came to my work at exactly 8:31AM on monday then I will out in exactly 3:31PM then it will calculate the remaining time as LATE HOURS. All in all I'm 2 hours and 1 minute (2:01)
Sorry Wawasimark,
I don't really understand your request.
M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks