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?

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

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.

Ask Your Question

Weekly Poll

Do you think Jony Ive could make a big impact on Airbnb?

Discuss in The Lounge

Poll History