SundanceStriping
New Member
- Joined
- Jul 23, 2014
- Messages
- 8
I am at a loss. I have tried for four days now to figure out a formula to calculate regular hours, overtime hours and total hours per day and per week.
My current time card is as follows:
B13-B20 = Sun (noon until) -Sun (until noon)
C-L = in & out times for all days of the week above
M13-N20 = regular hours
N13-N20 = overtime hours
O13-O20 = Total Hours
Also:
M21 = total weekly regular hours
N21 = total weekly overtime hours
o21 = total weekly hours
I have already formatted the in & out times, regular, overtime and hour times to show/calculate correctly according to time/decimal conversion.
My main issue is that I want the daily time to show in regular hour until 40 hours for the week has been met. Once met, I would like the hours for the day to be shown in the overtime column.
Please help! Thanks
My current time card is as follows:
B13-B20 = Sun (noon until) -Sun (until noon)
C-L = in & out times for all days of the week above
M13-N20 = regular hours
N13-N20 = overtime hours
O13-O20 = Total Hours
Also:
M21 = total weekly regular hours
N21 = total weekly overtime hours
o21 = total weekly hours
I have already formatted the in & out times, regular, overtime and hour times to show/calculate correctly according to time/decimal conversion.
My main issue is that I want the daily time to show in regular hour until 40 hours for the week has been met. Once met, I would like the hours for the day to be shown in the overtime column.
Please help! Thanks