LinkBack URL
About LinkBacks
Hello.
Good day!
Can anyone here help me on this.
I have daily attendance data and i need to calculate the time of each worker (day shift and night shift)
here is my workbook.
attendance sample.xls
Thanks in advance.
Hello.
Good day!
Can anyone here help me on this.
I have daily attendance data and i need to calculate the time of each worker (day shift and night shift)
here is my workbook.
attendance sample.xls
Thanks in advance.
Do you just want a count of the total number of days worked, or broken out by time? Also, does this need to be continuous?...or do you just need a count?
Spread the love, add to the Rep
"None of us are as smart as all of us."
Thanks for your response.
Do you just want a count of the total number of days worked, or broken out by time?
Broken out by time.
For instance:
employee timings:
Abhilash Pazhamkulangara 1/11/2014 7:58
Abhilash Pazhamkulangara 1/11/2014 13:00
Abhilash Pazhamkulangara 1/11/2014 13:59
Abhilash Pazhamkulangara 1/11/2014 17:01
i need to calculate the total timings for that particular day.
I used this formula
=SUMPRODUCT(--(C:C=C2),--(D:D=D2),K:K)
but it only sum up all the values.
So you want the total time elapsed for that particular day? As in for your example, would the result be 1 (as in that is one attendance day), or would it be 9:03, or the number of hours spent there?
Yes, it should be 9:03 or 9.05 (total number of hours spent).
Last edited by Ryan_Bernal; 12-08-2014 at 09:33 AM.
Hopefully last question; can you have helper columns?
yes if it requires.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks