Hours worked = pay

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

This probably seems a really simple formula for you all to work out, but I'm
not to clued up on Excel so forgive me!

In column B I will have a worker's shift start time and in column C the time
they finish. In D, I want the total amount of hours worked to be
automatically calculated and filled in. Also, in column E, I want the amound
of hours worked, say 4, multiplied by their hourly wage, eg. 4 x £5.70

Any ideas people?

Thanks
 
Hi
in D1 enter
=C1-B1+(C1<B1)
and format this cell as time

in E1 enter
=D1*24*5.70
and format this cell as number/currency
 
Back
Top