N
NEHicks
unit shift name start end
total hours
5D N Reyes, Victoria 0:00 8:00 8:00
5D D McKan, Pinky 7:30 16:00 8:00
3A E McKan, Pinky 15:30 24:00:00 8:00
4D N Wright, June 0:00 8:00 8:00
4D D Garcia,Jose 7:30 16:00 8:00
I am trying to get a summary of the total hours worked on a unit. I have
tried using =SUMIF(A1:A5,"5D", (F1:F5), which gives me a result of 1.0. I
have also tried using the CountA function but that doesn't return a correct
count either.
Any ideas would be appreciated.
total hours
5D N Reyes, Victoria 0:00 8:00 8:00
5D D McKan, Pinky 7:30 16:00 8:00
3A E McKan, Pinky 15:30 24:00:00 8:00
4D N Wright, June 0:00 8:00 8:00
4D D Garcia,Jose 7:30 16:00 8:00
I am trying to get a summary of the total hours worked on a unit. I have
tried using =SUMIF(A1:A5,"5D", (F1:F5), which gives me a result of 1.0. I
have also tried using the CountA function but that doesn't return a correct
count either.
Any ideas would be appreciated.