View Single Post
  #1   Report Post  
Roze
 
Posts: n/a
Default 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