Hours worked computation???

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)

Tom said:
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
Click to expand...
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)
 
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.
 
Back
Top