Software

Ask something
Discussion Locked

Time Sheet

0 helpful
4 replies

by bjjhome.bt

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Has anyone any idea how to calculate a timesheet where the total hours for the month are in the format "111:00" and this is reduced by formula after deducting the daily workinjg day????

PLEASE HELP - I am getting too thin on top for this

4 replies

by thechas

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

by chitosunday

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 discussion is closed to new replies.