View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lee lee is offline
external usenet poster
 
Posts: 184
Default Formula for a time sheet

I want to make the cell show the sum of a group of cells but stop at 40. For
example, a row of 7 cells labeled Mon thru Sun. A seperate cell is progammed
to shw the sum of those cells however I want the max to be 40 and anything
over 40 be deverted to seperate cell marked for overtime.
--
Lee Davenport