yogi_Compute Number Of Entries During Each Shift Shift Begin And Shift End Times Are Not On Same Day-02

Google Spreadsheet   Post  #2113

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-24-2017

question by Holiday Claims:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/wSuFOUUGqTg;context-place=forum/docs
Number of entries added between two different time-stamps, Not on same day

We start our shift at 11pm in the evening and finish 7am the next morning. What formula can I use to see how many entries are made during each shift?

18/01/2017 11:55:40	Day 1	Shift Starts 11pm 18/01/2017 Finishes 7am 19/01/2017
19/01/2017 06:55:40
19/01/2017 23:45:41	Day 2	Shift Starts 11pm 19/01/2017 Finishes 7am 20/01/2018
20/01/2017 00:00:07
20/01/2017 00:03:18	Day 3	Shift Starts 11pm 20/01/2017 Finishes 7am 21/01/2019
21/01/2017 00:03:18