Hello all, first (of many) post here.
When I pulled the data from my workplace's database, it was formatted something like this -
CreateDt Output
8/29/20 7:19 AM 1
8/29/20 7:19 AM 2
8/29/20 7:25 AM 3
8/29/20 7:25 AM 4
8/29/20 7:25 AM 5
8/29/20 7:25 AM 6
8/29/20 7:25 AM 7
8/29/20 7:25 AM 8
8/29/20 7:30 AM 9
8/29/20 7:30 AM 10
8/29/20 7:30 AM 11
8/29/20 7:30 AM 12
8/29/20 7:30 AM 13
8/29/20 7:30 AM 14
Now, I would like to count the output between 7:00am till 7:30am only, but without changing the cell's format (this is because, if I did, the next time I pulled the data it won't show).
I've added a column for Time only (using MOD(1,1)) like this -
CreateDt Time Output
8/29/20 7:19 AM 7:19:35 AM 1
8/29/20 7:19 AM 7:25:09 AM 2
8/29/20 7:25 AM 7:25:09 AM 3
8/29/20 7:25 AM 7:25:09 AM 4
8/29/20 7:25 AM 7:25:09 AM 5
8/29/20 7:25 AM 7:25:09 AM 6
8/29/20 7:25 AM 7:25:09 AM 7
8/29/20 7:25 AM 7:30:33 AM 8
8/29/20 7:30 AM 7:30:33 AM 9
8/29/20 7:30 AM 7:30:33 AM 10
8/29/20 7:30 AM 7:30:33 AM 11
8/29/20 7:30 AM 7:30:33 AM 12
8/29/20 7:30 AM 7:30:33 AM 13
8/29/20 7:30 AM 7:35:53 AM 14
And use this formula
But I am looking to simplified it even further and remove the Time Column.
Can anyone help?
When I pulled the data from my workplace's database, it was formatted something like this -
CreateDt Output
8/29/20 7:19 AM 1
8/29/20 7:19 AM 2
8/29/20 7:25 AM 3
8/29/20 7:25 AM 4
8/29/20 7:25 AM 5
8/29/20 7:25 AM 6
8/29/20 7:25 AM 7
8/29/20 7:25 AM 8
8/29/20 7:30 AM 9
8/29/20 7:30 AM 10
8/29/20 7:30 AM 11
8/29/20 7:30 AM 12
8/29/20 7:30 AM 13
8/29/20 7:30 AM 14
Now, I would like to count the output between 7:00am till 7:30am only, but without changing the cell's format (this is because, if I did, the next time I pulled the data it won't show).
I've added a column for Time only (using MOD(1,1)) like this -
CreateDt Time Output
8/29/20 7:19 AM 7:19:35 AM 1
8/29/20 7:19 AM 7:25:09 AM 2
8/29/20 7:25 AM 7:25:09 AM 3
8/29/20 7:25 AM 7:25:09 AM 4
8/29/20 7:25 AM 7:25:09 AM 5
8/29/20 7:25 AM 7:25:09 AM 6
8/29/20 7:25 AM 7:25:09 AM 7
8/29/20 7:25 AM 7:30:33 AM 8
8/29/20 7:30 AM 7:30:33 AM 9
8/29/20 7:30 AM 7:30:33 AM 10
8/29/20 7:30 AM 7:30:33 AM 11
8/29/20 7:30 AM 7:30:33 AM 12
8/29/20 7:30 AM 7:30:33 AM 13
8/29/20 7:30 AM 7:35:53 AM 14
And use this formula
COUNTIFS(Sheet1!$G:$G,">=" &TIME(7,0,0),Sheet1!$G:$G,"<" &TIME(7,30,0))
. Seems to work...But I am looking to simplified it even further and remove the Time Column.
Can anyone help?