Why won't the SUMIF function in Excel add time?
 

Why won't the SUMIF function in Excel add time?
 

Why can't you give an example of what you are talking about?

--
Don Guillett
SalesAid Software

"SKHRAANENMOENR" wrote in message
...

Why won't the SUMIF function in Excel add time?
 

It does.

.............A.............B
1.......10:00..........N
2.......12:15..........Y
3.........5:30..........Y
4.........1:27..........N

Column A formatted as h:mm

=SUMIF(B1:B4,"Y",A1:A4)

Formatted as [h]:mm

Result = 17:45

Biff

"SKHRAANENMOENR" wrote in message
...