Jump to content
We've recently updated our Privacy Statement, available here. ×

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

Matt Semmens 2

Recommended Posts

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...