Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-03-2018, 09:23 AM
Trapshooter1956 Trapshooter1956 is offline maximum total Windows 7 32bit maximum total Office 2007
Advanced Beginner
maximum total
 
Join Date: Mar 2017
Posts: 31
Trapshooter1956 is on a distinguished road
Default maximum total

I have a spreadsheet that tracks benefit time at work.


We are allowed to accumulate 40 hours of compensation time after that we have to take it in overtime.
what i need is a formula that quit accumulating at 40 then another that takes the excess each pay period and tracks that.
I have attached a sheet to show what i mean.

Thanks, Jerry.
Attached Files
File Type: xlsx Benifit Time-2017-1.xlsx (65.0 KB, 13 views)
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing in A3 using the maximum page area stuwoolf Excel 2 01-27-2015 11:54 AM
maximum total maximum number of columns weamish Excel 4 12-11-2014 12:59 PM
Relative Maximum End Date. aJacom Project 5 06-23-2012 10:51 AM
Is there a Maximum No of Slides per file David Thompson PowerPoint 0 11-04-2010 09:55 PM
Maximum limit on Inbox folders?? KarenK Outlook 0 12-29-2009 10:38 PM

Other Forums: Access Forums

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


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