| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating Due Date
I'm trying to create a formula to determine a due date. My due dates are calculate base on the date in column "A" and the time in column "B". The due date window is 2am to 1:59am. If and order is received by 1:59am it is due that same day by 12:30pm. If it is received after 2am it is due the following day by 12:30. The tricky part for me is the time between 12am and 1:59am. Any help would appreciated. A few examples A B C DATE RECEIVED TIME RECEIVED Would be Due By 3/27/2009 9:52:10 3/28 by 12:30pm 3/27/2009 14:14:17 3/28 by 12:30pm 3/28/2009 0:28:25 3/28 by 12:30pm 3/28/2009 1:19:02 3/28 by 12:30pm 3/28/2009 2:05:35 3/30 by 12:30pm 3/28/2009 2:49:20 3/30 by 12:30pm Thanks Little Penny |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating date and placing the value in the right date range col | Excel Discussion (Misc queries) | |||
| Calculating a date | Excel Worksheet Functions | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
![Little Penny[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
