S
SJUCatch27
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.
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.