Sun, 02 Sep 2007 07:30:51 GMT from Emerogork via OfficeKB.com <u36894
@uwe:
7:00am int A1, 3:00pm in B1. When I (B1 - A1) I get 0.33 but I want 8.
Thoughts?
The subtraction gives you fractions of a day. Multiply by 24 to get
hours and fractions of an hour.
If you want only whole hours, use INT() or ROUND() on the result.
--
"First prove what you're saying, then whine about it."
-- /The People's Court/
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/