I have figured out how to calculate regular hours and overtime hours on a
daily basis but now I need to take those calculations and determine if an
employee has worked over 37.5 hours in a week (2.5 hours would go to regular
time) and anything over 40 would go to overtime. Our spreadsheet allows each
employee to show each day's clock in and clock out times and then calculates
the regular hours and any overtime hours. I use the following formula for
the regular hours
(IF((($C14-$B14)+($E14-$D14)+($G14-$F14))*248,8,(($C14-$B14)+($E14-$D14)+($G14-$F14))*24)
and then the following formula for overtime hours
(IF((($C14-$B14)+($E14-$D14)+($G14-$F14))*248,((($C14-$B14+$E14-$D14+$G14-$F14)*24)-8),0)
where B is the in time, C is the out time, D is the in time, E is the out
time, F is the in time and G is the out time.
--
Michele