Hi,
Can some one help me with this please.
I need to create formula that calculates hours worked,
but some times the shifts going over the standart working shifts
i.e normal shift would be Monday to Friday 08:00 - 18:00 at this time its paid £20/h
but if the time goes after 18:00 or fells in the weekend i.e worked 17:50 - 18:15, then standard wage is £30/h
so there should be 10min paid by 0.33p and 15min paid by 0.50p.
I dont really understnad how to create criteria nor how it work, so if some one can help
me woth this i will really apperciate it
Thanks in advance for your help.
Can some one help me with this please.
I need to create formula that calculates hours worked,
but some times the shifts going over the standart working shifts
i.e normal shift would be Monday to Friday 08:00 - 18:00 at this time its paid £20/h
but if the time goes after 18:00 or fells in the weekend i.e worked 17:50 - 18:15, then standard wage is £30/h
so there should be 10min paid by 0.33p and 15min paid by 0.50p.
I dont really understnad how to create criteria nor how it work, so if some one can help
me woth this i will really apperciate it
Thanks in advance for your help.