ExcelBanter - SUMPRODUCT Question Adding Hours?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUMPRODUCT Question Adding Hours? (https://www.excelbanter.com/excel-discussion-misc-queries/245899-sumproduct-question-adding-hours.html)

wx4usa

SUMPRODUCT Question Adding Hours?

I have columns as follows:
A = Month Text
B = Year
C= Employee
D=time in
E= time out
F= Hours worked (Out minus in) Formatted as hours/minutes Time
format 5:45

I need a formula that works...mine doesnt.
=sumproduct((a10:a1000=August)*(b10:b1000=2009)*(c 10:c1000=Mike)*
(hours))

This formula returns a zero.

Thanks for your help!

muddan madhu

SUMPRODUCT Question Adding Hours?

=SUMPRODUCT(--(A2:A5="April")*(B2:B5=2009)*(C2:C5="a")*(F2:F5))

On Oct 19, 11:46*pm, wx4usa wrote:
I have columns as follows:
A = Month Text
B = Year
C= Employee
D=time in
E= time out
F= Hours worked *(Out minus in) Formatted as hours/minutes *Time
format 5:45

I need a formula that works...mine doesnt.
=sumproduct((a10:a1000=August)*(b10:b1000=2009)*(c 10:c1000=Mike)*
(hours))

This formula returns a zero.

Thanks for your help!

All times are GMT +1. The time now is 08:26 PM.