Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I need a little boost ...
cmnshiftdur is the number of hours of overlap of two shifts
tdiff is half that value
I am failing in thought as to how to ...
So if ecend = 3:00PM and tdiff = 1.5, the value in .Cells(DR, 2) = 1:30P
Rich (BB code):
cmnshiftdur = Round((ecend - lcstart) * 24, 1)
tdiff = cmnshiftdur / 2
cmnshiftdur is the number of hours of overlap of two shifts
tdiff is half that value
I am failing in thought as to how to ...
Rich (BB code):
.Cells(DR, 2) = the value of ecend (end time of shift as a time value) - tiff formatted as "h:mm a/p"
So if ecend = 3:00PM and tdiff = 1.5, the value in .Cells(DR, 2) = 1:30P