Pay rate Calculation for different shifts

S

Santosh

Can anyone help please?

I am trying to prepare a report for payment calculation for short term
continuous work. We are using 3 different shifts, First shift 06:00 - 14:00,
Second Shift 14:00 - 22:00 and night shift 22:00 - 06:00. The rate for first
& second shifts (day shifts) is same but night shift is double to day shift.
For holiday night shift rate is using. There is no specific time for start
and end the work. E.g. 07/11/07 09:36 - 10/11/2007 16:00. Please help me to
make a suitable formula for fined out the total amount to be paid for work.
 
M

Mike H.

Not sure I understand, but if you go by the time to determine the shift:
assume a1 contains start time
if(a1<22,Rate,Rate*2)

Or if shift is determined by the employee:

If("filelookup on employee to get Shift"<3,rate,rate*2)

HTH...
 
D

David Biddulph

Are you sure you want if(a1<22,Rate,Rate*2) ?
Wouldn't it be more likely to be if(HOUR(a1)<22,Rate,Rate*2) ?
 

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

Top