Add Time Q
^^^^ Thanks for your reply, but not really what I'm looking for, which
is a formula/function that can add up hours within each Hour segment
for a day, eg
The following clocks
Emp#1 In=09:30 Out=14:30
Emp#2 In=10:30 Out=14:55
Emp#3 In= 11:30 Out=15:30
So for the following Hour segments the formula/function should
return:-
09:00-10:00 = 30mins labour hours worked
10:01-11:00 = 90mins labour hours worked
11:01-12:00 = 150min labour hours worked
12:01-13:00 = 180min labour hours worked
13:01-14:00 = 180min labour hours worked
14:01-15:00 = 145min labour hours worked
15:01-16:00 = 30min labour hours worked
I have 300+ rows of data, so can't do it manually (not efficiently
anyway)
|