| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula which calculates the number of authorized days based upon
Generally, 1 day of travel time is allowed for each 350 miles of official
distance of ordered travel. If the excess is 51 miles or more after dividing the total number of miles by 350, one additional day of travel time is allowed. When the total official distance is 400 miles or less, 1 day's travel time is allowed. So if the total travel time was 750 miles this would only be 2 days of travel. 751 would be 3 days of travel....and so on |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula which calculates the number of authorized days based upon
Try this:
=CEILING(MAX(A1-50,50)/350,1) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "DeMangello1" wrote in message ... Generally, 1 day of travel time is allowed for each 350 miles of official distance of ordered travel. If the excess is 51 miles or more after dividing the total number of miles by 350, one additional day of travel time is allowed. When the total official distance is 400 miles or less, 1 day's travel time is allowed. So if the total travel time was 750 miles this would only be 2 days of travel. 751 would be 3 days of travel....and so on |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula which calculates the number of authorized days based u
This did exactly what I wanted.
"Ron Coderre" wrote: Try this: =CEILING(MAX(A1-50,50)/350,1) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "DeMangello1" wrote in message ... Generally, 1 day of travel time is allowed for each 350 miles of official distance of ordered travel. If the excess is 51 miles or more after dividing the total number of miles by 350, one additional day of travel time is allowed. When the total official distance is 400 miles or less, 1 day's travel time is allowed. So if the total travel time was 750 miles this would only be 2 days of travel. 751 would be 3 days of travel....and so on |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula which calculates the number of authorized days based u
Great! I'm glad that helped.
Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "DeMangello1" wrote in message ... This did exactly what I wanted. "Ron Coderre" wrote: Try this: =CEILING(MAX(A1-50,50)/350,1) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "DeMangello1" wrote in message ... Generally, 1 day of travel time is allowed for each 350 miles of official distance of ordered travel. If the excess is 51 miles or more after dividing the total number of miles by 350, one additional day of travel time is allowed. When the total official distance is 400 miles or less, 1 day's travel time is allowed. So if the total travel time was 750 miles this would only be 2 days of travel. 751 would be 3 days of travel....and so on |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| business day date from a specific date based on a number of days | Excel Worksheet Functions | |||
| Formula to count number of sequential days in a row | Excel Worksheet Functions | |||
| FORMULA THAT CALCULATES HH:MM ON THIRD SHIFT(BETWEEN TWO DAYS) | Excel Discussion (Misc queries) | |||
| Calculates Dates Based on 7 day week excluding Holidays | Excel Discussion (Misc queries) | |||
| What is the formula for adding a number of days to an existing dat | Excel Worksheet Functions | |||
Linear Mode
