troubleshooting Question

Excel Formula

Avatar of Rrave26
Rrave26 asked on
Microsoft Excel
11 Comments1 Solution339 ViewsLast Modified:
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:

Scenario #1
Service availble date, AX, can be null.  In this case the result should be 0:00:00

Scenario #2
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

Scenario #3
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?
ASKER CERTIFIED SOLUTION
Ken Butters

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros