|Subject:||Results of formula vs real numbers|
|Posted by:||J.W. Aldridge (jeremy.w.aldrid…@gmail.com)|
|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
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.