Hi i need a help for formula
Working days
1.Monday to Thursday =36 hrs
2. Friday =8 hours
i need to calculate OT for this in follwoing format.
Mon Tue Wed Thu Fri
std hours 9 9 9 9 8
ot calculation if day is monday (actual time worked-Std time(i.e 9hrs) the whole week ot must be summed in one cell
12.00 12.00 12.00 12.00 11.00 OT =15 HOURS
Bookmarks