Skip to main content

I have this working formula to return 'Reaction Hours'...

ROUND(DATETIME_DIFF({Reacted Date & Time},{Request Date & Time},'minutes')/60,2)
 
If the request and reaction times are equal, 0.00 will be returned (correctly).  But then I embed it in an IF statement (simply to prevent #ERROR outputs if 1 of the input fields hasn't been populated yet)...
 
IF(AND({Reacted Date & Time},{Request Date & Time}), ROUND(DATETIME_DIFF({Reacted Date & Time},{Request Date & Time},'minutes')/60,2),"")
 
Now it works fine apart from the situation where a zero is returned, in which case the result is empty/blank.  Both date fields are present, so the first part of the IF statement is triggering, but for some reason the 0.00 value is replaced by empty/blank. 
 
Any ideas why?  

Hm, could you try removing the `,""` at the end there?  So just:

IF(
AND({Reacted Date & Time},{Request Date & Time}),
ROUND(
DATETIME_DIFF(
{Reacted Date & Time},
{Request Date & Time},
'minutes'
)
/ 60,
2
)
)

I think that should show you the 0 like you want

Hm, could you try removing the `,""` at the end there?  So just:

IF(
AND({Reacted Date & Time},{Request Date & Time}),
ROUND(
DATETIME_DIFF(
{Reacted Date & Time},
{Request Date & Time},
'minutes'
)
/ 60,
2
)
)

I think that should show you the 0 like you want


that worked great thanks!  I thought I had to specify an else condition in these if statements but I guess not.  No idea why the else condition was triggered though since both the values of the AND statement were present.  Either way you fixed the bug so thanks again!

Reply


Terms & Conditions