Microsoft Office Forums How to create a formula using the IF in a time sheet.

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-25-2013, 10:56 AM
spaul spaul is offline How to create a formula using the IF in a time sheet. Windows 7 32bit How to create a formula using the IF in a time sheet. Office 2010 32bit
Novice
How to create a formula using the IF in a time sheet.
 
Join Date: Oct 2013
Posts: 1
spaul is on a distinguished road
Default How to create a formula using the IF in a time sheet.

Hello all I'm new to this forum and I need a little help on creating this formula. I need to add the IF as part of the formula here's what i would like to do after inputing the hours worked IF greater than 6 deduct .5, I created the formula which adds the hours, dollars and overtime.



any suggestions is appreciated.
Reply With Quote
  #2  
Old 10-25-2013, 11:28 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to create a formula using the IF in a time sheet. Windows 7 64bit How to create a formula using the IF in a time sheet. Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Hi
perhaps post a small sample sheet showing what you want to do?
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #3  
Old 10-26-2013, 11:43 PM
Kevin@Radstock Kevin@Radstock is offline How to create a formula using the IF in a time sheet. Windows 7 32bit How to create a formula using the IF in a time sheet. Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2012
Posts: 91
Kevin@Radstock is on a distinguished road
Default

Perhaps something along these lines:

=IF(cell_ref>6,cell_ref-0.5,cell_ref)
Reply With Quote
  #4  
Old 10-28-2013, 07:19 PM
BobBridges's Avatar
BobBridges BobBridges is offline How to create a formula using the IF in a time sheet. Windows 7 64bit How to create a formula using the IF in a time sheet. Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 614
BobBridges will become famous soon enoughBobBridges will become famous soon enough
Default

Or a variation thereof:
Code:
=cell_ref-IF(cell_ref>6,0.5,0)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a formula using the IF in a time sheet. Create a resource sheet in MS Project chabuk1 Project 8 05-01-2012 12:59 PM
How to create a formula using the IF in a time sheet. create tree list in excel sheet chuikingman Excel 5 06-27-2011 09:38 AM
How to create a formula using the IF in a time sheet. Sheet load time markg2 Excel 2 06-01-2011 06:00 PM
Please help me create this formula... doublejoy Excel 1 08-22-2009 03:04 AM
How to create a formula using the IF in a time sheet. Enter Number on any sheet one time only. paulrm906 Excel 1 04-28-2006 07:35 AM


All times are GMT -7. The time now is 01:07 PM.


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