Adding/Subtracting Dates & Times

[Guest]

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.

 

[Pete_UK]

Try this in C2:

=B2-A1

Format C2 as d " days" hh:mm.

Hope this helps.

Pete

 

[daddylonglegs]

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")