matthewajackson13
New Member
- Joined
- Aug 29, 2019
- Messages
- 2
I am trying to merge 4 date and time cells together into 1 cell. I am using the following formula:
=CONCATENATE(TEXT(Table_query__42[@[Soft Lock 1 End]],"mm/dd/yyyy h:mm AM/PM"), "; ",TEXT(Table_query__42[@[Soft Lock 1 Start]], "mm/dd/yyy h:mm AM/PM"), "; ",TEXT(Table_query__42[@[Soft Lock 2 End]], "mm/dd/yyy h:mm AM/PM"),"; ",TEXT(Table_query__42[@[Soft Lock 2 Start]], "mm/dd/yyyy h:mm AM/PM"))
It is working to combine all of the dates however, the blank fields are showing up as 01/00/1900 12:00 AM.
I would like the blank fields to show up blank.
Is there a way to combine 4 date and time cells together and exclude blank cells? I have tried to combine the cells without the formatting however, it brings them together as just numbers and not dates.
Any help would be great. Some example data set below:
<tbody>
</tbody>
=CONCATENATE(TEXT(Table_query__42[@[Soft Lock 1 End]],"mm/dd/yyyy h:mm AM/PM"), "; ",TEXT(Table_query__42[@[Soft Lock 1 Start]], "mm/dd/yyy h:mm AM/PM"), "; ",TEXT(Table_query__42[@[Soft Lock 2 End]], "mm/dd/yyy h:mm AM/PM"),"; ",TEXT(Table_query__42[@[Soft Lock 2 Start]], "mm/dd/yyyy h:mm AM/PM"))
It is working to combine all of the dates however, the blank fields are showing up as 01/00/1900 12:00 AM.
I would like the blank fields to show up blank.
Is there a way to combine 4 date and time cells together and exclude blank cells? I have tried to combine the cells without the formatting however, it brings them together as just numbers and not dates.
Any help would be great. Some example data set below:
09/25/2019 8:00 AM | 9/25/2019 12:00 PM | 10/01/2019 8:00 AM | 10/01/2019 12:00 PM |
9/25/2019 8:00 AM | |||
09/25/2019 8:00 AM | 9/25/2019 12:00 PM | ||
<tbody>
</tbody>