how do i calculate the difference in time?
Hi guys... I have a similiar query.... plzzzz can someone help me!
I'm constructing a spreadsheet to work out the difference in time and date;
A1 A2 A3
07/11/04 11:00 04/11/04 10:00 3:1:00 (d:h:mm)
but now i'm trying to work out a fomula that if it goes over one day the
formula would work out true/false... i've tried doing the following but it
doesn't work;
=IF(A3=1,"Failed","Met") but it doesn't work...... doesn't seem to
register the day
Thank you
|