Oh, im sorry. my mistake for the "tab" part.

I tried using "<=" but it doesn't compute the date and time difference.
I also tried using the TEXT command but still doesn't work.



"Fred Smith" wrote:

Don't you simply want "<=" as opposed to just "="? Try:
=SUMPRODUCT(((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)<=(DATA!$K$2:$K$5000-DATA!$J$2:$J$5000))
"))

In the future, using the correct terminology will get you better responses.
F, G, J and K are columns, not tabs.

Regards,
Fred

"Neri" wrote in message
...
I used
=SUMPRODUCT(((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)=(DATA!$K$2:$K$5000-DATA!$J$2:$J$5000))
")) to compute if a person passed or
failed in our activity. the problem now is that, I didn't noticed the date
and time they submitted their reports.

For ex.

F G

1/2/2008 4:00:00 PM 1/2/2008 6:00:00 PM


J K
1/2/2008 4:00:00 PM 1/2/2008 5:00:00 PM


F and G tab are for the planned start and end period and the J and K tab
are
for the actual start and end period. If I use the formula above, the
person
will fail because the difference of time is not equal wherein the person
should pass bec he submitted his report 1hr ahead of his planned time. How
am
I supposed to calculate the difference of the date and time? can you
please
help me. Thanks!

*please also considered the date period