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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excell 2007 Dates and combining 2 cells 6
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Complicated Formula Problem 10
How to enter start and end date/time in excel based on some specific value. 7
I copied Visible Cells Only, but it pastes only the first cell 1
combining multiple cells with IF statements 3
combine two cells and keep data 2
Moving a part of a cell to another cell 5

Back
Top