i'm trying to create a timesheet where i can calculate the normal hours, overtime and weekend hours.

Here is the sheet im working on: https://docs.google.com/spreadsheets/d/1S4l2txvsjLQnWC4O5D3C0wj5kJWoeocNP7y4f2YOLcg/edit?usp=sharing

So far i managed to get the list of dates calculate hours worked and which is overtime but what i can't figure out is how to calculate the worked hours on weekends, because i have 3 rates to pay(for normal hours, overtime and if worked on weekend.

I could to that if i put like a check box next to each date and manually select the weekends but i wonder if i could do it automatically.

PS. :D the sheet looks ugly but i'm trying to get everything working then i will work on the design.

I'm trying to create a timesheet where I can calculate the normal hours, overtime and weekend hours.

Here is the sheet I'm working on: https://docs.google.com/spreadsheets/d/1S4l2txvsjLQnWC4O5D3C0wj5kJWoeocNP7y4f2YOLcg/edit?usp=sharing

So far I managed to get the list of dates calculate hours worked and which is overtime, but what I can't figure out is how to calculate the worked hours on weekends, because I have 3 rates to pay  (for normal hours, overtime and work on weekends).

I could to that if I put like a check box next to each date and manually select the weekends, but I wonder if I could do it automatically.