Posted on 2014-08-04
I have a a spreadsheet where I am calculating elapsed time of calls. I have one cell called Service avaiable date and time, cell AX, and another called IM Engaged date and time, cell AR. Here are the scenarios I can run into:
Service availble date, AX, can be null. In this case the result should be 0:00:00
IM Engaged date,cell AR, 07/16/2014 18:04 is greater then the service availble date, cell AX, 07/16/2014 17:35. Result should be 0:00:00
Service availble date,cell AX, is greater, 07/16/2014 18:04 then IM Enaged date,cell AR, 07/16/2014 17:35. Result should be 0:29:00.
I tried a nested if formula, =IF(AX283="",0,IF(AR283>AX283,0,AX283-AR283) with no success. What am I missing here?