This is the format I am working on.

And I am doing it on a monthly basis.

So basically,

From the days, I get number of working days for any given month and store it in a cell. In the image, its 22.

Check in, and Check out and Break calculates the Worked time for a day. Sum of worked hours make a week and 4 weeks make a month, give or take. So total worked hours in a month, is calculated and stored in a cell. In the image, its 186:00.

So I have the number of work days a month (22), and number of worked hours (186:00).

Now I need a way to convert the 22 days into number of workable hours. So that I can find the OT with the difference.

I am right now calculating it once in general format, and entering it manually as a hh:mm format.

**EDIT**Problem solved.

I did what you said.

Changed the format of the cell to [hh]:mm and multiplied the number of days with (4/24). And viola. I have number of workable hours. Best part is, I can change the project hours as I want now.

Thanks a ton!