how do u times hours by wages

  • Thread starter Thread starter Nikki
  • Start date Start date
N

Nikki

im trying to create a roster on excel but i cant times the hours my staff
worked by there wage cost?
i have in b2 1:30AM
b3 4:30PM then in b5 the total is 3:00 the formula i used was =b3-b2+(b3<b2).
i want to times b5 by there wage cost $16.00
i dont know what else to do or if i have done that last formula wrong?
please help Nikki
 
=MOD(B3-B2,1)*16

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top