Time Sheet

Let me first see if I have the problem straight in my mind.

You require a minimum work month of 111:00 hours.

When calculating time, you subtract time worked from the minimum, and then do something with any extra time worked.

Start by setting the cell format to time in hours and minutes.

Set up a cell for each day, and enter the time worked.

Set up a cell to total the time worked.

Set up a reference cell with the value of 111:00

Then, set up 2 results cells.

Required hours remaining:
if(reference cell (-) hours (>) 0, reference cell (-) hours, 0)

Extra hours:
if(hours (-) reference cell (>) 0, hours (-) reference cell, 0)

Chas

format the cell as [h]:mm so it will not be converted to days but total hrs and minutes.
You must know that the hour value is just equivalent to a fraction of 24 hrs so 2 hours is equivalent to 2/24. 30 minutes is equivalent to
(30/60)/24.

This question was closed by the author

You can download Free Ready Excel Timesheet Templates at http://www.calculatehours.com/timesheet-template-library.html