| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtract 12 hours from date/time
I am trying to subtract 12 hours from a date/time cell if the date in B1 is
greater than A1. A1 3/3/2010 2030 (formatted: m/d/yyyy hh:mm) B1 3/4/2010 1030 (formatted: m/d/yyyy hh:mm) No matter how I format A1, B1 and C1 I still get a #Value error. I am obviously missing something or leaving something out. Any help is greatly appreciated. Cindy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours | Excel Worksheet Functions | |||
| using if statement to subtract 24 hours from time | Excel Worksheet Functions | |||
| How do I subtract 8 business hours from a date/time value? | Excel Discussion (Misc queries) | |||
| Subtract hours from a time and get the correct time | Excel Worksheet Functions | |||
| Time/Date subtract 24 hours | Excel Discussion (Misc queries) | |||
Threaded Mode
