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.