| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with formula =MAX(A1-40,0)
I was using the formula =MAX(A1-40,0) to seperate overtime hours from total
hours worked on a time sheet. The cell was formatted "general". Now I need to format the cells "[h]:mm" but the formula no longer works with that cell formatting. Is there a fix? -- Lee Davenport |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula percentage problem | New Users to Excel | |||
| formula problem | New Users to Excel | |||
| Problem with nested logical formula. | Excel Worksheet Functions | |||
| problem with Array Formula | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Threaded Mode
