Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2014, 10:27 PM
brandon0409 brandon0409 is offline Timesheet and calculating over 40 hours Mac OS X Timesheet and calculating over 40 hours Office for Mac 2011
Novice
Timesheet and calculating over 40 hours
 
Join Date: Apr 2014
Posts: 1
brandon0409 is on a distinguished road
Default Timesheet and calculating over 40 hours

I'm keeping track of my hours from work on my own spreadsheet.

Scenerio:

1 Column (A1 - A5) Each cell containing a day's hours;
A1 = Monday
A2 = Tuesday
etc.



A6 = The week's total hours

What I want to do:

When I've reached 40 hours, anything over 40 will appear in an adjacent cell and calculate how many hours OVER 40 (My overtime) that I have accumulated.

I want it to do this automatically without me having to have multiple cells doing multiple other calculations. Or using some other nonsense jerry-rig.

Hopefully my explanation is clear.
thanks for any assistance.
Reply With Quote
  #2  
Old 04-26-2014, 12:18 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Timesheet and calculating over 40 hours Windows 7 64bit Timesheet and calculating over 40 hours Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi and welcome in A7 enter =MIN(40,A6) ( or instead of 40 refer to a cell containing the limit) in A8 enter =MAX(0,A6-40) (same remark)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Profits? MarkL Project 1 06-12-2012 07:19 AM
Form file timesheet, auto fill date from calander jkeeney Word 1 03-21-2012 12:21 AM
Timesheet and calculating over 40 hours calculating duration ketanco Project 5 12-15-2011 07:15 PM
Timesheet and calculating over 40 hours Timesheet formula IndCom Excel 12 05-27-2011 01:27 PM
Timesheet and calculating over 40 hours Timesheet formula help beardking Excel 2 11-10-2009 02:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:01 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