Adding/Subtracting Dates & Times

K

Kim17740

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.
 
D

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