#1




Need help with IF formulas for work timesheets
Hi Everyone,
I need help please. I want to add a formula but not sure how to do it, i googled but its not giving me the info I need. in our timesheet excel i have made i want to ad the following: 1. IF the employee worked 8 hours the value should be 7.6 (if its less it should show what the value is) I got the 1st part but not the second it just gives me the word FALSE 2. IF it is 8 hour (7.6) then he should get 0.4 is it is not 8 then is should be 0 So basically what I want it to do is the following: If you worked 8 hours then it is 7.6 + 0.4 = 8 if you worked less than 8 hours it is jut 7.6 + 0 = 7.6 I don't know how to do this in excel. Please see attached what i have done. Thanks Tash 
#2




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 
#3




Hi Andrew,
Thank you so much for helping me out, if I get stuck again Ill just shout out. Thanks Tash 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Timesheets to Invoices  Time being imported as days  dave6084  Mail Merge  1  11022019 11:01 PM 
Formulas of an embedded excel in powerpoint don't work unless I double click them  Martin_Ko  PowerPoint  0  10052017 05:57 AM 
Fixing Work, % of actual work and Final Date in a task (while assigning resources)  Campelliann  Project  1  01092017 06:15 PM 
Multiple Timesheets  id'ing two people working on the same machine at the same time.  Will  Excel  1  09282016 09:12 AM 
infopath for timesheets & project management  eekoh  Misc  0  02242015 07:57 AM 