combine date & time in one cell

  • Thread starter Thread starter Dawn
  • Start date Start date
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
 
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
 
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
 
Back
Top