Calculating Time

Hi, So I have got 2 tables.   For instance, table x and table y. Table x is basically a snapshot or the same table as table y, however table x is a snapshot taken at the start of a day at 05.30am ...