Dates

[charly1]

Hi all.
I am relatively new to Excel, so despite the feeling that my q may be quite simple, Ime still finding it tricky to work it out alone. Any help would be greatly appreciated.
I have a table that lists in one column the date and time [in the same cell] of when a specific worker clocked in, and then in the adjacent column, the date and time of when he clocked out.
I have already created a couple of adjacent columns that work out the amount of hours minutes and seconds that each session actually took.
On the last column i am trying to write formula that will work out how much the worker is to be paid for that piece of work. My problem is that the wages vary, and although standard pay is 50 dollars per hour, work that was performed from Friday morning 6am until Sunday 6am gets paid 70 dollars per hour.
How would i write a formula, that works out the amount of money the worker is to be paid, taking into account when the work was performed.

Thank you so much for any help in advance!

num	began work	ended work	hours	minutes	seconds	50 per hour pay
1
2
3
4
5
6
7
8

 

[SanjayGMusafir]

My problem is that the wages vary, and although standard pay is 50 dollars per hour, work that was performed from Friday morning 6am until Sunday 6am gets paid 70 dollars per hour.
How would i write a formula, that works out the amount of money the worker is to be paid, taking into account when the work was performed.

You better do 2 things
Add a column that gives total time work in Hours-minutes in Decimals

Second, We can add IF function in wages formula using Weekday.Intl function where Friday to Sunday morning gets paid @ 70/hour and for rest @50/hour

Only challenge would be where an employee starts either before Friday 6 am or works after Sunday 6 am in one go...

Rather than giving a blank table, give some actual data to work with and give solution. Also Share any such data with any of the challenges I have mentioned (if any) to find a solution