Hello,
Ok, perhaps a strange one, but I'm in need of a formula for the following please.
D3
Shift Start: 5:00AM (or 5 in 24 hour time)
E3
Shift End: 4:00PM (or 16 in 24 hour time)
What I need is to show is all hours between the two 24 hour times:
5 (Start time)
6
7
8
9
10
11
12
13
14
15
16 (Final hour worked based on "Shift End" entry)
Also need the same for 2nd shift hours which spans across Midnight:
17
18
19
20
21
22
23
0
1
2
3
I can get the 24 hour time returned from my starting and ending shifts, but can't figure out how to show each of the hours worked in a column between the two numbers.
Thank you for your time.
Jay.
Bookmarks