Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding a sum to the quarter hour. | Excel Worksheet Functions | |||
rounding up time to quarter hour increments | Excel Worksheet Functions | |||
rounding up time to quarter hour increments | Excel Worksheet Functions | |||
rounding up time to quarter hour increments | Excel Worksheet Functions | |||
Rounding time to nearest Hour | Excel Worksheet Functions |