republican-creole
site Search:


 
    All Forums Hot Topics Gallery






how-to block ads


 
Search Topic:
Share Topic
Posting?
Post a:
Post a:
Links: ·MS Apps FAQ ·Windows XP FAQ ·Windows 7 FAQ ·Windows Home ·Office Home
AuthorAll Replies


tao
Chaos Impends
Premium
join:2000-12-03
Lansing, MI

reply to tao

Re: [Excel] Figuring overtime and assign a value

Played with that sheet a bit more and got the zones working with a compromise. The cells for the zones were split into two columns, with the right being for zone 4 and the left for zone 3, then the cells having numerical values was counted and a function was added to the top list to handle those numbers.

But like I wrote in the previous post, if you need the sheet to have all the features you showed in your example, then simply place the calculations on sheet B and link them to A.
--
I play darts: »www.triple20dartingsupplies.com | »www.adaoflansing.com
I support unions: »www.1099alldrivers.org www.1039atu.com

Saturday, 02-Jun 13:31:39 Terms of Use & Privacy | feedback | contact | Hosting by nac.net - DSL,Hosting & Co-lo
over 12.5 years online © 1999-2012 dslreports.com.
Most commented news this week
Hot Topics