If I'm working in the 1900 date system and my differences are less than
31 days, your formula works for me.

The formula I used in A3 was =A1-A2, formatted as "d:h:mm"

In the 1904 date system however, the "d" will be one day off, since "d"
refers to "day of the month". Since the zeroth day is 1/1/1904, a value
of 0.5 formatted as "d:h:mm" returns 1:12:00, not 0:12:00.


In article ,
"Roze" wrote:

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