I don't know if you're explaining properly or not. I get exactly what
you say you want, so I'm afraid I can't help you much.

I put an example workbook up on my ftp site. It gives the correct
results for me:

ftp://ftp.mcgimpsey.com/excel/roze_demo.xls


In article ,
"Roze" wrote:

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