hello, I need help for a formula. I have been struggling with this. Grateful to have some help. The week starts on Monday. From Monday to Friday the working hours are 8hrs and on Saturdays it is 5 hours. I need to calculate the overtime based on the total hours per day(th) in cell. The conditions are as follows. if the (th)cell is 0:00, then it must return 0:00,if it is weekday(mon to fri) it must deduct 8 hours from the total hoursif the total hours for the weekdays is less than 8hr or 8hrs it must return 0:00 for the overtimeif it is a Saturday , 5hrs must be deducted from the (th)cellif the (th) is less than 5hrs for saturday, it must return 0:00 as overtimeif it is a sunday, it must return same value hrs as in cell(th) Please help.

HansVogelaar Thank you so so much! i was struggling with this for a long time. Thank you so much for helping me out.

Copper Contributor

Aug 06, 2021

Solved

formula for weekday and overtime

hello,

I need help for a formula. I have been struggling with this. Grateful to have some help.

The week starts on Monday. From Monday to Friday the working hours are 8hrs and on Saturdays it is 5 hours.

I need to calculate the overtime based on the total hours per day(th) in cell. The conditions are as follows.

if the (th)cell is 0:00, then it must return 0:00,
if it is weekday(mon to fri) it must deduct 8 hours from the total hours
if the total hours for the weekdays is less than 8hr or 8hrs it must return 0:00 for the overtime
if it is a Saturday , 5hrs must be deducted from the (th)cell
if the (th) is less than 5hrs for saturday, it must return 0:00 as overtime
if it is a sunday, it must return same value hrs as in cell(th)

Please help.

ASP-01
Aug 07, 2021
HansVogelaar

Thank you so so much! i was struggling with this for a long time. Thank you so much for helping me out.