Format of BinByDateTime output HH:M when it should be HH:MM

[Matt Semmens 2]

Good morning,

I have hundreds of products being scanned every hour, each scan has a line of data, and each line of data has a timestamp.

I wanted to bin these scan lines by hh:mi, and use these time bins as the X axis on a graph.

I created a calculated column with the following:

BinByDateTime([scanned Timestamp],"hh.mi",1)

I then used this on the X axis, everything is ordered correctly however the formatting is odd and I can't find a way to fix it.

The time 09:15 appears as 09.15, but the time 09:09 appears as 09.9, so the minute column is sometimes only 1 character long.

Has anyone else come across this problem and is there an easy solution

Please see attached screenshot of graph.

[Matt Semmens 2]

Used this messy method to fix the problem

 

Time(left(String(Time([scanned Timestamp])),5))