Excel Formula

G

Gary

does anyone know what formula I should use for the
following:

Example:
If an employee starts at 3:30pm and works until 7:00pm
and within that time there are 2 different pay rates
(ordinary and PM) is there a formula that you can set
parameters for the would identify the two pay rates. For
example it the answer would be 2 hours at Ordinary rate
and 1.5 hours at PM rate. What formual would I use to get
this result?
 

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