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

7.00
7.15
7.30
7.45
8.00
8.15
8.30
8.45
10.10
9.15
9.30
9.45
10.00
10.15
10.30
10.45

<colgroup><col style="mso-width-source:userset;mso-width-alt:8996;width:185pt" width="246"> </colgroup><tbody>
</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