Adding/Subtracting Dates & Times
 

Here's the setup:

A1=Date Received (formatted m/d/yyyy hh:mm)
B2=Date Sent (formatted m/d/yyyy hh:mm)
C2=Turnaround Time

I need a formula in C2 that will give me the turnaround time in d:hh:mm.

Please let me know if I need to adjust the formatting in A1 & A2.

Thanks.

Adding/Subtracting Dates & Times
 

Try this in C2:

=B2-A1

Format C2 as d " days" hh:mm.

Hope this helps.

Pete

Adding/Subtracting Dates & Times
 

Pete's solution works fine for up to 32 days. If you may have longer
periods try

=INT(B2-A1)&" days "&TEXT(MOD(B2-A1,1),"hh:mm")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=532112