Matt Semmens 2 Posted January 30, 2020 Share Posted January 30, 2020 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 More sharing options...
Matt Semmens 2 Posted January 30, 2020 Author Share Posted January 30, 2020 Used this messy method to fix the problem Time(left(String(Time([scanned Timestamp])),5)) Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now