| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtract 12 hours from date/time
Actually my formula was the same as yours, but I had the time in A1 and B1
formatted incorrectly. I was putting in 2030 (true military time) instead of 20:30 which is what Excel wants. Thanks for your help though! Cindy "FSt1" wrote: hi would have been nice if you had posted your formula so someone might see what your are doing wrong. excel keeps time as a decimal value of a day. 12 hrs = .5 day assuming that your date/time that you are subtracting is A.... =IF(B1A1,A1-0.5,0) post back with more details. maybe we can refine it more. regards FSt1 "Cindy" wrote: 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
