|
|
#2
01-17-2023, 08:44 PM
|
||||
|
||||
The If formula has three parts: Test,ValueIfTrue,ValueIfFalse. You only provided a ValueIfTrue so when the False state is triggered you didn't tell the formula what to do. That is fixed by adding that to the formula in cell F6
=IF(H6>=7.6,7.6,H6) But I would use a simpler formula in cell F6 and then copy it down =MIN(7.6,H6) That will give you the actual hours up to a maximum of 7.6
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Timesheets to Invoices - Time being imported as days
|
dave6084 | Mail Merge | 1 | 11-02-2019 11:01 PM |
| Formulas of an embedded excel in powerpoint don't work unless I double click them | Martin_Ko | PowerPoint | 0 | 10-05-2017 05:57 AM |
| Fixing Work, % of actual work and Final Date in a task (while assigning resources) | Campelliann | Project | 1 | 01-09-2017 06:15 PM |
| Multiple Timesheets - id'ing two people working on the same machine at the same time. | Will | Excel | 1 | 09-28-2016 09:12 AM |
| infopath for timesheets & project management | eekoh | Misc | 0 | 02-24-2015 07:57 AM |
Windows 10 
Office 2016
Threaded Mode