View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
The_Sleeper The_Sleeper is offline
external usenet poster
 
Posts: 1
Default Payouts based on hours and rounding down if hour is not in list.

Hello all
I have a time sheet setup for drivers to enter time start time and
end time. From there they mark down how many hours.

Q R
1 Hours Price
2 4 $6.00
3 8 $12.00
4 12 $18.00
5 18 $24.00
6 20 $30.00
7 24 $36.00
So for there time i pay them for meals. if they work 4 hours they get
$6.00 and so on. but i would like to setup a formula that will round
down. if they worked 6 hours i will pay them for 4 and if they work 9
i will pay them for 8 and so on. if any one could help i would be
greatful...


Thanks..
The Sleeper