Power Pivot - Concatenate (Date) Date and (Text) Time

[rck]

Good afternoon!
I need to concatenate two columns; one is a date and the other is a time that is formatted as text.

All of my attempts to convert the CALL_CREATED_TIME field to an actual time field have failed since I am not proficient in Power Pivot. Ultimately, I would like the CALL_CREATED_DTTM field to contain the CALL_CREATED_DATE+ " " +CALL_CREATED_TIME columns and formatted as mm/dd/yyyy hh:mm:ss.

Thank you in advance!

 

[Matt Allington]

Why do you want to do this? Best practice is to not combine date and time columns.
assuming the time is in format hhmmss, you can use functions like LEFT, Right, Mid to extract the hours, mins and secs, and then use TIME to convert.

 

[rck]

Why do you want to do this? Best practice is to not combine date and time columns.
assuming the time is in format hhmmss, you can use functions like LEFT, Right, Mid to extract the hours, mins and secs, and then use TIME to convert.

I need to calculate the duration between multiple date + time fields. Thanks for your reply!

 

[Matt Allington]

you can use the functions I describe above.