Hi Alexander

Did you try it?
The date alters as well as the time.
If you are adding more than 24 hours then
=A1+50/24 would be the same as adding 2 days and 2 hours.

--
Regards

Roger Govier


"Alexander" wrote in message
...
Yes, but what if I want the weekday change after time has been
accumulated
over 24 hrs? Any chances?

"Roger Govier" wrote:

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!