| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Calc in hours
I'm trying to perform a date calc to produce a variance in hours
ex cell A1 3/27/2006 2100, cell B1 3/28/2006 0100, cell C1 =b1-a1, results I would like to see is 4 This spreadsheet will be used for scheduling so both positive and negative numbers will be used for variance numbers. -- Mark W. Hanford |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours to a date | Excel Worksheet Functions | |||
| Hours and minutes display as date in formula box | Excel Discussion (Misc queries) | |||
| rounddown with date calc? | Excel Discussion (Misc queries) | |||
| Calc End Date | Excel Worksheet Functions | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
Threaded Mode
