Results of formula vs real numbers

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


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


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


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

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


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.