Adding hours scheduled for week
Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula}"
=SUMPRODUCT(IF(MOD(COLUMN(C5:P5),2)=0,C5:P5)-
IF(MOD(COLUMN(C5:P5),2)=1,C5:P5))
If this post helps click Yes
---------------
Jacob Skaria
"Wet Nose" wrote:
Jacob,
My employee's times actually go horizontal so start times would be cells
C5,E5,G5,I5,K5,M5,O5, and end times would be cells D5,F5,H5,J5,L5,N5,P5 and
the sum cell would be Q5. Thanks for your help :)
Sheila
"Jacob Skaria" wrote:
Forgot to mention to format the formula cell to [h]:mm
If this post helps click Yes
---------------
Jacob Skaria
"Jacob Skaria" wrote:
With data arranged as below try the formula
Col A Col B
9:30 AM 3:30 PM
10:30 AM 3:30 PM
8:30 AM 3:30 PM
8:30 AM 3:30 PM
9:00 AM 3:30 PM
=SUMPRODUCT(B1:B5-A1:A5)
If this post helps click Yes
---------------
Jacob Skaria
"Wet Nose" wrote:
I have created a work schedule with start/end time cells formated hh;mm
AM/PM. The "total hours scheduled" cell is formated [h]:mm. I need a
formula for the "total" cell that will add the weekly shifts. Ex; Monday
10-5 + Tuesday 12-8 etc. equals 15:00 I've tried to SUM (time out-time in)
and it will work for one day, but I can't figure out how to add the remaining
work days - all it get is errors. Please help!
|