LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rounding a sum to the quarter hour. Susan Excel Worksheet Functions 3 June 29th 07 06:42 PM
rounding up time to quarter hour increments kdp145 Excel Worksheet Functions 5 March 15th 06 12:05 AM
rounding up time to quarter hour increments kdp145 Excel Worksheet Functions 1 March 14th 06 07:11 PM
rounding up time to quarter hour increments kdp145 Excel Worksheet Functions 0 March 14th 06 06:43 PM
Rounding time to nearest Hour SierraRose Excel Worksheet Functions 1 July 24th 05 02:57 AM


All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"