With the start time in A1 & finish time in A2 try:

=FLOOR((A2-A1),6/60/24)*24

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"DBane" wrote in message
...
I am a truck driver. There are no set start times nor finish times . we
start when the load is ready and punch out when delivery is complete. we
are
paid in increments of 6 minutes. For example if I start at 8:00am and
punch
out at 4:06pm payroll records the time as 8.1 hours. I have an employee
time
sheet from the Excel 2000 Formulas book thats excellent its on page 168.
I
need a frmula that converts minutes into increments of 6. its always
rounded
down to nearest increment.