Add Time Q
Progress of sorts, the formula below will show me the number of
instances that Clocks occurred between 11am-12pm, so I can equate
1=60mins, but it can't handle partial hours, so if some one was
clocked in at 11:15am, it should return 45mins, but doesn't it returns
1 (60 mins)
=SUMPRODUCT(--(C$8+$AC41=In_Time),--(Out_Time=(C$8+$AC41-
TIME(0,59,59))))
|