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.
EDITProblem 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!