how do u times hours by wages

[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

 

[Bob I]

=(b3-b2+(b3<b2))*b5

 

[Bob Phillips]

=MOD(B3-B2,1)*16

--
HTH

Bob

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