Hours worked computation???

[Guest]

Hi All
I am developing a excel spreadsheet for employees of our business
My question..
I would like to have a sum in the column that adds the daily hours for a weekly total. The tricky part is, in that column, I would like it to show up to a maximum of 40 hours and if the employee's hours exceed that then the hours in excess of 40 would be displayed in another column (overtime
I believe there has got to be a formula for that...it is???

Tom

 

[Bob Phillips]

A21: =MIN(SUM(A1:A20),40)
A22: =MAX(SUM(A1:A20)-40,0)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi All,
I am developing a excel spreadsheet for employees of our business.
My question...
I would like to have a sum in the column that adds the daily hours for a

weekly total. The tricky part is, in that column, I would like it to show
up to a maximum of 40 hours and if the employee's hours exceed that then the
hours in excess of 40 would be displayed in another column (overtime)

 

[Wouter]

Tom,

If you are using format "hh:mm" for start and endtime end the time
worked each day, use "[hh]:mm" as format string for those cells to
show hours excedding 23:59:59.