View Single Post
  #5   Report Post  
Akern
 
Posts: n/a
Default

Ron! Thank you so very very much! I knew there had to be a mathematical
solution, but I didn't know how Excel was calculating the numerical value!
You are a life saver!!!

Thanks!
Amy

"Ron Rosenfeld" wrote:

On Mon, 18 Apr 2005 11:50:01 -0700, "Akern"
wrote:

I have created an electronic time sheet in Excel. I am trying to find out if
I can convert hours and minutes in time format into fractions of hours in
numerical format. Any ideas? Thanks!


Excel stores time as fractions of a day. So just multiply by 24 and format as
numeric (or General).


--ron