R
richard.littlewing
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/2008 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
I did receive two responses but both options didn't work as expected.
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/2008 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
I did receive two responses but both options didn't work as expected.