Hi there, 

I have a spreadsheet that calculates a time. I want to automate a count of how many are >3:00 and <3:00.

I use =SUMIF(M2:M110,”<3:00″)

But instead of getting an answer with a whole number, I’m getting a strange percentage .21 ? (The column format is set to general, I changed it to number and it didn’t make a difference).

Likewise, when I run it for >3:00; I get 3.12 …

What am I doing wrong?

Thanks
Sarah

​Hi there, I have a spreadsheet that calculates a time. I want to automate a count of how many are >3:00 and <3:00.I use =SUMIF(M2:M110,”<3:00″)But instead of getting an answer with a whole number, I’m getting a strange percentage .21 ? (The column format is set to general, I changed it to number and it didn’t make a difference).Likewise, when I run it for >3:00; I get 3.12 …What am I doing wrong? ThanksSarah  Read More

​