SQUIDD
Well-known Member
- Joined
- Jan 2, 2009
- Messages
- 2,104
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi All
So this one has been getting to me. Im trying to simply convert the afternoon times to 24hr.
I collect data from a website. Some of this data is times, but all in time order. like below. Before 12 is am and after 12 is pm.
When i run the code to obtain these times, it will only ever give me future times. So, as below would be if i run the code to get the times in the morning.
8:12
9:57
10:27
11:34
12:22
01:02 - i would like to get 13:02
02:34 - i would like to get 14:34
if i run the code to obtain the times in the afternoon, it would look like this
12:22 i would like to get 12:22
01:02 i would like to get 13:02
02:34 i would like to get 14:34
03:33 i would like to get 15:33
04:12 i would like to get 16:12
10:33 i would like to get 22:33 - just to cause issue
I hope the obove makes sense.
I will continue to try to figure it out, i was trying to be clever and convet as i obtained the time during my for loop when collecting elements from website, but make change this and simlly run a routine at the end to covert.
thanks for looking
Dave
So this one has been getting to me. Im trying to simply convert the afternoon times to 24hr.
I collect data from a website. Some of this data is times, but all in time order. like below. Before 12 is am and after 12 is pm.
When i run the code to obtain these times, it will only ever give me future times. So, as below would be if i run the code to get the times in the morning.
8:12
9:57
10:27
11:34
12:22
01:02 - i would like to get 13:02
02:34 - i would like to get 14:34
if i run the code to obtain the times in the afternoon, it would look like this
12:22 i would like to get 12:22
01:02 i would like to get 13:02
02:34 i would like to get 14:34
03:33 i would like to get 15:33
04:12 i would like to get 16:12
10:33 i would like to get 22:33 - just to cause issue
I hope the obove makes sense.
I will continue to try to figure it out, i was trying to be clever and convet as i obtained the time during my for loop when collecting elements from website, but make change this and simlly run a routine at the end to covert.
thanks for looking
Dave
Last edited: