Dear all,

If A1 is equal to Mon 1300, and when I plus another 12hrs in A2, it will
become Tue 0100 in A2.

Any idea how to achieve this?

Thanks!