Forum Discussion

SeanC1970's avatar
SeanC1970
Copper Contributor
Mar 15, 2019

Need help with simple timesheet formula

Sorry, my skills with excel are limited, but I'm sure this will be a simple formula for most. Here's what I have and what I'm trying to achieve.   Cells  A-E all have a value of "10", representing ...
excel
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Mar 16, 2019
F1=MIN(SUM(A1:E1),40)
G1=SUM(A1:E1)-F1
  • SeanC1970's avatar
    SeanC1970
    Copper Contributor
    Mar 16, 2019
    Both suggestions work. Thanks so very much. I'm still tweaking my sheet to best suit my needs, but now at least my numbers match.

Resources