Concatenate

[Milo Bloom]

Hello: I am trying to Concatenate 2 rows. date then time

Say
A B C D
11/14/18 12:05 Looking for 11/14/18 12:05 HH:MM
11/13/18 10:32
This is old data so I don't want to retype it like column C

I need to subtract the rows to get total Hours between the 2 dates

TIA

Milo

 

[SpillerBD]

If the Date is a DateValue and the Time is a TimeValue, just add + them together.
If these are text, work with DATEVALUE. Use the & operator to combine the necessary text to your local default.

 

[Milo Bloom]

Wow thanks for the help. I sure took the hard approach to that one. I knew the were just numbers and completely forgot about it.

Thanks again
Milo