Anonymous ID: f49088 Jan. 7, 2018, 2:59 p.m. No.18359   🗄️.is 🔗kun   >>8377 >>8429

Possible consideration for anyone working on markers and a clock.

 

Ignoring dates, only using time stamps.

 

A clock face only has 12 hours. 1:00 and 13:00 appear the same. If placement using a 12 hour face yields anything, it will show how intricately it has been planned.

 

Good luck.

Anonymous ID: f49088 Jan. 7, 2018, 3:14 p.m. No.18485   🗄️.is 🔗kun   >>8581

>>18429

Depends on the state of the data.

 

If timestamp is in a separate cell: pseudocode:

If(stamp >12:00, then stamp -12:00, else stamp)

 

Sort by calculated column. I'm mobile for now. If things were scraped/sorted sensibly this is the easiest task