PDA

View Full Version : EXCEL Time Value Manipulation



21-04-1999, 07:00 PM
How can I convert an EXCEL time value, e.g 8:45(eight hours and 45 minutes) to hours and decimals of an hour (8.75)? As far as I can see, none of the built in functions do it directly, and I haven't managed to work out any other way.