View Single Post
  #3   Report Post  
Roze
 
Posts: n/a
Default

I'm trying to work out a spreadsheet that works out the differenct date and
time difference... e.g:

A1 A2 A3 A4
Recieved Date/Time Replied Date/Time Total Met/Failed
04/11/04 10:00 05/11/04 11:00 1:1:00

I need a Met/Failed column(Met= 1) (Failed=0) which automatically works it
out if it's taken more than 1 day to reply to the email, then it's 0 (Failed)

I tried doing the follwing formula but it doesn't work;
=IF(A3=1,"0","1")

Please can you help.....

Thank you!!!


"Bob Phillips" wrote:

If you give us some idea of what you mean, maybe.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Roze" wrote in message
...
Can some plzzz help