Thread: Excel Work Hours and Time Calculation Help

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.

Hi DILIPandey,

I attached an excel sheet with the columns, can you please apply the format you are referring to and repost it? Im not quite sure where to apply the values because I have two time slots.

Thank you so much for all your help. Do you know how you would go about adding the net hours together?

Nevermind I was able to add the hours in the cell by using the custom format [h]:mm. Do you know how to multiply the custom format by a number so I can calculate my pay?

Right now its 888:00