How to calculate out of hours?

Mar 30, 2013
Reaction score
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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question