Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2023, 07:26 PM
Tash14 Tash14 is offline Need help with IF formulas for work timesheets Windows 10 Need help with IF formulas for work timesheets Office 2021
Novice
Need help with IF formulas for work timesheets
 
Join Date: Jan 2023
Posts: 2
Tash14 is on a distinguished road
Default 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
Attached Files
File Type: xlsx Help .xlsx (13.7 KB, 1 views)
Reply With Quote
  #2  
Old 01-17-2023, 08:44 PM
Guessed's Avatar
Guessed Guessed is offline Need help with IF formulas for work timesheets Windows 10 Need help with IF formulas for work timesheets Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote
  #3  
Old 01-18-2023, 03:31 PM
Tash14 Tash14 is offline Need help with IF formulas for work timesheets Windows 10 Need help with IF formulas for work timesheets Office 2021
Novice
Need help with IF formulas for work timesheets
 
Join Date: Jan 2023
Posts: 2
Tash14 is on a distinguished road
Default

Hi Andrew,

Thank you so much for helping me out, if I get stuck again Ill just shout out.

Thanks
Tash
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with IF formulas for work timesheets 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft