Mod(decimal hours,1) will get you part hour
if this is divided by 0.6 you will get your decimal minutes
so multiply this by the hourly rate

if minutes in cell A1 and rate is in b1
mod(a1,1)/0.6*b1 will work out the payment


if hours and minutes are in A1

(int(a1)+mod(a1,1)/0.6)*b1 will work out the payment

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=515275