finding the delay from one day to maybe 3 day later

  • Thread starter Thread starter jladika
  • Start date Start date
J

jladika

hello
i am looking for a formula
can you direct me to where i can find it?
I am looking for this

a study was completed on 4/1/2004 @ 8:00a
our paper work was sent 4/2/2004 @ 7:00a
the report was returned 4/4/2004 @ 8:00P
I need to find out what the time delay is between each of the above
 
Hi
try the following formula
=INT(B1)-INT(A1)-(MOD(B1,1)<MOD(A1,1)) & " days " &
TEXT(MOD(B1,1)-MOD(A1,1)+(MOD(B1,1)<MOD(A1,1)),"hh:mm")
 
thanks for the help
can you please email me at (e-mail address removed)
so you can help me with this problem thanks
joe
 
thanks for the formula
i need some help in how to use it
is it all one formula that goes in one cell?

please help me as how to set this up
thanks jo
 
Back
Top