Convert times to 24 hour clock

[hazzaska]

Hi
I am having trouble converting times, i can get it to work so far but all times with a zero at the end show as 3 digit, is there a way to convert it properly please?

thanks for any help

D

<colgroup><col style="mso-width-source:userset;mso-width-alt:8996;width:185pt" width="246"> </colgroup><tbody>
[TD="class: xl64, width: 246"]7.00[/TD]

[TD="class: xl64"]7.15[/TD]

[TD="class: xl64"]7.30[/TD]

[TD="class: xl64"]7.45[/TD]

[TD="class: xl64"]8.00[/TD]

[TD="class: xl64"]8.15[/TD]

[TD="class: xl64"]8.30[/TD]

[TD="class: xl64"]8.45[/TD]

[TD="class: xl64"]10.10[/TD]

[TD="class: xl64"]9.15[/TD]

[TD="class: xl64"]9.30[/TD]

[TD="class: xl64"]9.45[/TD]

[TD="class: xl64"]10.00[/TD]

[TD="class: xl64"]10.15[/TD]

[TD="class: xl64"]10.30[/TD]

[TD="class: xl64"]10.45[/TD]

</tbody>

 

[Caleeco]

Hello,

Should be able to do this with a formula.
Are your numbers stored as text? or stored as numbers?

Thanks
Caleeco

 

[MARK858]

Cross-posted without a link here