Hi,

I'm trying to figure out the elapsed time (or the turnaround time) between
two dates at work. I have input it as such:

Date Received: 5/4/07 3:41 PM
Date Due By: 5/8/07 1:40 PM

Using this formula: =(DAY(G5)-DAY(F5))&" days and "&TEXT(G5-F5,"h:mm")

For that specific time frame, the formula works perfectly. I have this for
an answer: 4 days and 21:59

However, when these two dates come up, I have a problem.

Date Received: 4/30/07 4:26 PM
Date Due By: 5/3/07 1:00 PM

For that date range, I bring this back for an answer: -27 days and 20:34

I know, in theory, why it is pulling back that answer, but does anybody know
what adjustments I could make to the formula to bring me back the answer I'm
looking for? Thanks a lot.