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
|