Perspective table query

To fix the table column order go to the table PROPS, columns, and set the field name for column 0 to “In_time” and column 1 to “Out_time”. You must use capital letters exactly as returned by the query.

For background colours see if the answers to my similar question help. Perspective Table - Invididual Cell Conditional Formatting.