Your previous examples had values in a column, (e.g., A1, A2, A3), so
that's what the proposed solutions were based on, but your latest
example shows the values in rows.

Did you change the reference appropriately? e.g.,

A3: 01/11/04 11:00
B3: 02/11/04 13:00
C3: B3-A3 === 1:2:00
D3: IF(C3=1,0,1) === 0

????



In article ,
"Roze" wrote:

1) 04/11/04 10:00 04/11/04 17:00 0:7:00 TRUE
2) 04/11/04 08:00 04/11/04 08:00 0:0:00 TRUE
3) 01/11/04 11:00 02/11/04 13:00 1:2:00 TRUE

I'm sorry for being such a pain.........

If you take a look at rows 1 and 2 they are correct but the formula you gave
me doesn't work for 3... as it should be false because it's taken 1d 2hr 00m
to reply to email......

is their another way to work this spreadsheet, perhaps work only in hours
(aslong as it includes hours from both days and then do a formula for <24
hrs???

Thank you for all your help so far... very much appreciated!!!!

"JE McGimpsey" wrote:

What does "it doesn't work" mean to you?

Including your values in quotes makes them Text, but they should still
show up. Remove the quotes for numeric values, or use XL's implicit
conversion of TRUE/FALSE to 1/0 in math formulas:

= --(A3 < 1)



In article ,
"Roze" wrote:

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