Date format Reordering

[ollyhughes1982]

[FONT=&quot]Hi. Please see link to the relevant file, below:[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]https://1drv.ms/x/s!AtIvkRgReIvwgRPV4fmLEL1-gjz-[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I have a problem that I can’t seem to solve. I have this list of times and positions, with the times in hh:mm:ss format. However, the times have the minutes and and seconds in the wrong positions. e.g. Cell B2 shows 17:08:00 (17 hours, 8 minutes and 0 seconds), but this is meant read 00:17:08 (o hours, 17 minutes and 8 seconds)[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Other than re-typing them manually into the correct positions, is there a quick way to rearrange their order correctly?[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Thanks, Olly.[/FONT]

 

[kweaver]

Re: Date format Rerdering

Will this resolve it if filled down the C column? I think there will be an issue when you have a value in column B showing 24 as the hours because that will show up as the 0-hour.
Possibly an IF statement within the TIME function, but I haven't tried it yet.

=TIME(0,HOUR(B2),MINUTE(B2))

 

[Tetra201]

Maybe

=B2/60

 

[ollyhughes1982]

Thank you so much, this worked a treat! Can't believe I didn't think of that - so simple!