site Search:


Home Reviews Tools Forums FAQs Find Service ISP News Maps About  
 
    All Forums Hot Topics Gallery






how-to block ads

  
Forums >

OS and Software > Microsoft Help > [Excel] Figuring overtime and assign a value

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


PapaDos
Cum Grano Salis
Premium,MVM
join:2001-02-08
Lasalle, QC
kudos:2
1 edit

reply to neonhomer

Re: [Excel] Figuring overtime and assign a value

In J30, enter this:

=SUMPRODUCT( ($J$15:$J$29={"1","2R","2D","3R","3D","4R","4D"}) * {0,0,0,0,60,0,90} )

Adjust the second vector values according to your needs...
--
Festina Lente
to forum · permalink · 2009-06-19 07:44:32 ·
Forums > OS and Software > Microsoft Help

Saturday, 02-Jun 13:34:11 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