Change time format

[Davebro]

I want to change the time format

Time
1:40	13:40​
1:50	13:50​
2:05	14:05​
2:15
2:25
2:35
2:45
2:55
3:10
3:20
3:30
3:45
3:55
4:05
4:20
4:30
4:40
4:55
5:05
5:30
6:00
6:30
7:00
7:30
8:00

 

[SanjayGMusafir]

Time format has to be HH:mm

 

[Alex Blakenburg]

You seem to be assuming that all the times are after midday.
If you can rely on that you could try:

=A2+0.5

 

[Davebro]

=A2+0.5

Hi, many thanks for sorting this for me.

 

[Alex Blakenburg]

You're welcome. Glad we could help,