Subtract dates and times for overtime ...and also consider weekends and holidays
PLEASE PLEASE HELP
I need help with a formula to deduct ie dates and times to calculate regular time and overtime and multiply the regular time with the basic salary of R18.75 (Rand)....and Saturdays with Basic x1.5 ...and Sundays & public Holidays with basic salary x2 (The Holidays for 2020 I will past into the same space where the current holidays for 2019 are situated - =U9:U22...(Holiday dates need to also be included when calculating fomula please.
The colum J must calculate regular hours and colums K calculate Overtime hours for that specific row
What makes this difficult is that we sometimes work for 26 hours on end thus regular time & overtime spans over 2 days to be calculated and that is what I'm battling with
I have manually calculated the regular hours (J3:J6) and the overtime hours (K3:K6) as a reference for your perusal
It seems I cannot add my Example.xlsx file on this forum
I would so appreciate it if an Excel genius can assist me in this regard
Kind regards
Willie
Last edited: