You need to calculate your time as such:

(End time - Start time) multiplied by 24 then the result multiplied by
$4. format this cell as Currency.

Example:

A1 is the start time (13:00)
B1 is the end time (16:50)
C1 is the rate ($4.00)
D1 (formatted as Currency): =(B1-A1)*24*C1

This returns $15.33

good luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=475077