I am trying to create a formula that will help me figure out how many hours I am working a day. Easy enough.

However, if I work more than 7.5 hours I get one hour break that is unpaid and if I work less, I get .5 break unpaid.

I tried to create a formula in excel using the IF function without avail. For example: =IF(D2>=7.5,D2-1,(IF(D2<=7,D2-0.5,D2*1))).

The problem is when I subtract one time from another it is in a format which includes the : symbol which I cannot include in my excel formula. I currently have column E in General format, but when I convert it to time it shows the formula as #####.

Is there any way to get rid of the time difference in the HH:mm (Hours:minutes) format and have it something like H.m?

I have posted a link of the image here: http://screencast.com/t/WkFhVmNjaELR

Any thoughts? Thank you mathies.