Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to obtain the transit time
Hallo,
Column A I insert a date (Departing date) Column B I insert another date (Arrival date). I would like with Vba (vba because sometimes I might need to adjust the B30 date) once I input a date from cell A30 to obtain in B30 another date plus a value in A20 (transit time) with the following checks: - date in B30 = date in A30 - date in B30 = today's date - date in B30 + A20 (skip Sat. and Sundays) For example: Column A20 = 3 (transit time) Column A30 = 17 jan 2013 (departing time) Column B30 = 22 jan 2013 (arrival time) Thanks for any help and/or suggestions. Regards Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
28/10/2009 10:00 am calculate transit hours 75 hrs = total calcula | Excel Discussion (Misc queries) | |||
How to I subtract two dates & times to obtain a time | Excel Discussion (Misc queries) | |||
How To Obtain The Top 10% | Excel Discussion (Misc queries) | |||
Creating and transit time excel formula | Excel Discussion (Misc queries) | |||
Formula Needed for Transit Time | Excel Discussion (Misc queries) |