combine date & time in one cell

N

Niek Otten

If they are really just a date and a time: =A1+B1 (if A1 is date and B1 is
time). But mostly there is some date and some time part in both cells,
although it is not shown. In that case, use

=INT(A1)+MOD(B1,1)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
L

LoucaGreen

Can you be a little more specific?

If they are both in date format, then all you have to do is to ad
them.

If they are in any other format you may need to use @date() an
@time().

L
 
L

LoucaGreen

Can you be a little more specific?

If they are both in date format, then all you have to do is to ad
them.

If they are in any other format you may need to use @date() an
@time().

L
 
Top