ItsCasperX
New Member
- Joined
- Mar 7, 2022
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
So, I’m making a sheet that is named (Sheet 1) at the moment and I have 4 settings of time there is 5,15,30,60mins on cell (N11). It starts and ends at 14:00-18:00, the increments of time that I have above is what it goes based on. So if the cell says “5 mins” then it will go like 14:05,14:10 all the way to 18:00.
But i Need to help adding onto more time, somedays we have to add another 15,30,60 to that time frame, so instead of it being 14:00-18:00 it will be 14:00-18:15 & 14:00-18:30 & 14:00-19:00, but I want it to follow the increments of the time that is being followed. so, if it goes by 5mins but we need to go up by 30 mins(14:00-18:30) I want it to be 30mins but with a increment of 5mins, so it will be 18:05, 18:10, 18:15, to 18:30. Can someone help me with it.
But i Need to help adding onto more time, somedays we have to add another 15,30,60 to that time frame, so instead of it being 14:00-18:00 it will be 14:00-18:15 & 14:00-18:30 & 14:00-19:00, but I want it to follow the increments of the time that is being followed. so, if it goes by 5mins but we need to go up by 30 mins(14:00-18:30) I want it to be 30mins but with a increment of 5mins, so it will be 18:05, 18:10, 18:15, to 18:30. Can someone help me with it.