View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Creating a Work place time sheet.

How can I make one cell keep adding once another cell reaches maximum of
8:00.
Im trying to calculate overtime in a seperate column after employees enter
Start/Finish times from drop-down cells.


Assuming your hours are in H1, you can use a formula something like this to
track the OT hours...

=IF(H18,H1-8,"")

You will have to adjust this (the 8) to account for how the hours are stored
in H1; but conceptually, that is probably the approach you are looking for.

Rick