| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL 2003 Dates & elapsed time
Elegant formula help needed. the 4 cells concerned a
Date received, Date Claimed, storage start date and Elapsed days. Whe if the goods are claimed in less than 24 hours NO elapsed days and no storage date show. If than 1 day then storage date starts as Date Received +1and elapsed days begin. Storage chard=ges are driven by elapsed time. This formula of mine doesn't work and is to clumsy anyway. =IF(K5-J5<=1,"",IF(K5-J51,J5+1)) Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate elapsed time between dates and times | Excel Worksheet Functions | |||
| Ref: Formula to calculate elapsed time between certain dates and t | Excel Discussion (Misc queries) | |||
| Need Elapsed Time Help | Excel Worksheet Functions | |||
| Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
| elapsed time | Excel Worksheet Functions | |||
Threaded Mode
