Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
We have a 35 hour work week. I am trying to calculate the number of hours
between 35-40, then number of hours between 35-40 if over 40, and if under 35, then it shows 0. I can do it with 2 formulas on seperate lines then doing an IF statement, but waswondering if it is possible to do it as 1 function. Thanks. -- Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Hours | Excel Worksheet Functions | |||
Calculating hours | Excel Worksheet Functions | |||
Calculating Hours | New Users to Excel | |||
Calculating hours | Excel Worksheet Functions | |||
calculating hours | Excel Worksheet Functions |