Solved I want to count time stamps by day of the week and shift.

September 5, 2013 at 09:15:57
Specs: Windows 7
I have an array of approximately 16,000 time stamps in an Excel file. I want to count the time stamps by day of the week and shift (midnights, days, and afternoons). The shifts run from Midnight to 7:59:59 and 8:00 to 15:59:59 and 16:00 to 23:59:59. Any suggestions on how to count by day and shift?

See More: I want to count time stamps by day of the week and shift.

Report •


#1
September 5, 2013 at 09:36:34
I would imagine either the COUNTIF or the COUNTIFS functions
would be able to accommodate what your looking to do, although
you would probably need to add a second formula to get the Shifts
sorted out.

Read this how to then post and example of your data:

http://www.computing.net/howtos/sho...

MIKE

http://www.skeptic.com/


Report •

#2
September 5, 2013 at 09:41:52
Thanks; I have used the COUNTIF function but never used and didn't even know about the COUNTIFS function. I will give it a try. Thanks again.

Report •

#3
September 5, 2013 at 10:29:48
✔ Best Answer
The =COUNTIFS function is new in 2007.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question