Tuesday, January 24, 2017

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:
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