No. I have a cell with 7.30 in it, representing the difference between 4
times, morning in, lunch out, lunch in, evening out... The hours worked total
7 hours and 30 minutes in the format of 7.30. I need to convert it to 7.5 for
7 and 1/2 hours...

"Mexage" wrote:

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!