Let me see if I understood:

You have a cell with 1:30 PM, and you want to convert it to 1 1/2 ?


"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!