| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using if statement to subtract 24 hours from time
Hi all
I am trying to subtract 24 hours from a time if it is actually over 24 hours, if not then show 0 my formula works for everthing over 24 hours but can't get it show a 0 or under 24 hours. In A1 8/3/2008 7:21 in B1 8/6/2088 15:36 in C1 I have =if(("B1-A1")(A1+"1"),(B1-A1)-"1",0) The answer is 56:15:00 which is what I want but if B1 is 8/3/2008 it is showing ##### indicating a negative time number instead of 0 any help would be appreciated Richard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| How do you subtract time as in a timecard to calculate hours work | Excel Worksheet Functions | |||
| Time/Date subtract 24 hours | Excel Discussion (Misc queries) | |||
| Subtract time between certain days/work hours? | Excel Worksheet Functions | |||
Threaded Mode
