Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
150
Views
Topic starter
Hello All....
I need to define my day as
06:00 -14:00 1st Shift
14:01 - 22:00 2nd Shift
22:01 - 05:59 3rd Shift.
When I bring data in from my source file to analyze I would like to know if there is a way to change the date column to make sure the date change does not occur at 00:00.
B2 = Date
C2 = Time (h):mm:ss
When C2 goes past 0:00:00, I want to B2 to stay on the date needed to reflect a 06:00 - 06:00 hr day.
any help would be greatly appreciated!
C
Posted : 13/09/2022 9:11 am
Hi Chris,
Wondering where the date comes in in relation to the time. Do you currently have a formula in the date column? If so, what is it?
If you could attach an anonymized file, that would be great.
Riny
Posted : 14/09/2022 7:24 am
