EXCEL gurus??

[outlawx]

The ones earlier in the thread that are working will do even.

It’s 1 and 0 because we are dividing the cell number by 2 and looking at the remainder. So 0 for even cells and 1 for odd cells.

 

[pumbaa]

I'm pretty good but not an expert.

 

[golfinnut]

Still can't get it

 

[outlawx]

Let’s make this simple. It looks like you want am and pm data correct?

Format the time stamp to 24 hours and just slap in the following code

=SUMIFS(C:C,B:B,"<"&TIMEVALUE("12:00:00"))
=COUNTIFS(B:B,"<"&TIMEVALUE("12:00:00"),C:C,"<>")

Then take the sum/count for an average. This will do the morning set


=SUMIFS(C:C,B:B,">="&TIMEVALUE("12:00:00"))
=COUNTIFS(C:C,B:B,">="&TIMEVALUE("12:00:00"))

This will get your afternoon sets. This setup will also help you troubleshoot if any of the formulas are wrong.

 

[golfinnut]

Let’s make this simple. It looks like you want am and pm data correct?

Format the time stamp to 24 hours and just slap in the following code

=SUMIFS(C:C,B:B,"<"&TIMEVALUE("12:00:00"))
=COUNTIFS(B:B,"<"&TIMEVALUE("12:00:00"),C:C,"<>")

Then take the sum/count for an average. This will do the morning set


=SUMIFS(C:C,B:B,">="&TIMEVALUE("12:00:00"))
=COUNTIFS(C:C,B:B,">="&TIMEVALUE("12:00:00"))

This will get your afternoon sets. This setup will also help you troubleshoot if any of the formulas are wrong.

Yes

 

[DataDude]

I want a Power Bi thread