| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date and Time formula
I have a date & time as follows in one cell: 1/10/06 15:00.
I would like to create a formula in a differenct cell that automatically deducts 8 hours of the time above. Instead of 1/10/06 15:00, the new cell should show 8 hours less than that. When I take the above and take 8 off, it deducts 8 days. But I only need it to deduct 8 hours. Ideas anyone? Thanks. STS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| Time Date Formula Problem | Excel Worksheet Functions | |||
| Date and Time Formula | Excel Worksheet Functions | |||
Threaded Mode
