| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date and time differences revisited
OK Here's what I need.
Column A = Dates and times (in one cell) B1 = FIXED DATE C1 = Needs to equal the hours elapsed between column A and the fixed time in B1. Here's the catch: I only can count the hours elapsed of a 24 hour business day. The dates and times in column A can be of any set (weekends and holidays included). 03373 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Format differences | Excel Worksheet Functions | |||
| Greater than/Less than a certain Time (revisited) | Excel Worksheet Functions | |||
| Calculating differences in time. PLs Help | Excel Discussion (Misc queries) | |||
| Calculating Date AND Time Differences | Excel Worksheet Functions | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
Hybrid Mode
