Calculate dates and times for regular time & overtime ...and also consider weekends and holidays

blacktie

New Member
Joined
Feb 5, 2014
Messages
12

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:

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,223,888
Messages
6,175,217
Members
452,619
Latest member
Shiv1198

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top