I certainly can compress the date and time fields into a Modified Julian Date Number: “54,100.125” stands for “Monday, January 1, 2007, 3 p.m.” But then what ?
Below are 4 sample tables:
Table A has two record per day/date (morning and evening observations)
Table B has 24 records per day/date...