This formula still doesn't work, maybe it's me not explaning myself
properley......
What i need to do is
d:h:mm
e.g: 1:2:00 should = 0
0:2:00 should = 1
because if we complete the email within the 24 hrs (1day) then it should be
0, otherwise it should be 1, I've been trying various formula's to help me
but nothing calculates the D3 column correctly.......

D3: IF(C3=1,0,1) === 0



"JE McGimpsey" wrote:

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")