Results of formula vs real numbers

Giganews Newsgroups
Subject: Results of formula vs real numbers
Posted by:  J.W. Aldridge (jeremy.w.aldrid…@gmail.com)
Date: Thu, 24 Jul 2008

HI.

How do you change a formula to read the value as a result of a formula
and not necessarily as a real number?

Example:

In G6, i have the following formula that gives me the hour of a time
in F6

=IF(F6>0,MOD(F6-"1:00",1),"")

F6 contains 00:30:08,  The result is 23

In another cell, I am using this formula, but it doesnt recognize the
23.

=SUMPRODUCT(--(B6:B58331="james"),--(G6:G58331="23"))

The 23 is actually the HOUR of time so it isn't a whole number or real
number persay. It is a rounded time to the hour.

Replies