[Clock In] is a Time column. The data in the spreadsheet is โ12:38:00โ
[Clock in Timestamp column. The data in the spreadsheet is โ15/07/2021 12:38:32โ
Why are they displaying as 2 different time formats? If it matters, they are both being written by an action using TimeNow() and Now()
Dont really want to have a add another column and use a formula to sort this.
Solved! Go to Solution.
I did quickly through a time into a virtual column below are the results. โฆ
โฆWell, just as I was posting this, things seemed to have returned to normal!!!
Original Screenshot
Now Screenshot
The Time shown in the Timestamp is just plain wrong. There is no such time as โ00:38:32 pmโ.
And of course the Time field format should include the โpmโ. I assume you have โIgnore secondsโ turned on
Yes on that Time. Also tried turning that on for the datetime but it may no difference
I did quickly through a time into a virtual column below are the results. โฆ
โฆWell, just as I was posting this, things seemed to have returned to normal!!!
Original Screenshot
Now Screenshot
Yup the Appsheet fairies have been in and fixed it for me too
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |