Hi Alexander

Excel stores time as fractions of a day, so 12 hours = 0.5. So in A2
=A1+0.5

If you were wanting to add times that were not as simple as that, e.g. 5
hours, then
=A1+5/24
or
=A1+TIME(5,0,0)

--
Regards

Roger Govier


"Alexander" wrote in message
...
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!