How to concatenate two 'Time' fields into one formula field - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Kieran BrayKieran Bray 

How to concatenate two 'Time' fields into one formula field

Hi,

I have two 'Time' fields - 'Start__c' & 'Finish__c'. How can I concatenate these into one formula field? ie. '08:00:00 - 10:00:00' and which formula field type is most appropriate?

The closest half-solution i have found is using a text formula field and using:
TEXT(Start_Time__c) + ' - ' + TEXT(Finish_Time__c)
But this displays as: '08:00:00.000  - 16:00:00.000' and I don't know how to reduce the decimal places. 

Thanks!

Best Answer chosen by Kieran Bray
Tony TrinhTony Trinh
Hi Kieran,

Try this:
SUBSTITUTE(TEXT(Start_Time__c) + ' - ' + TEXT(Finish_Time__c), ".000", null)

All Answers

Tony TrinhTony Trinh
Hi Kieran,

Try this:
SUBSTITUTE(TEXT(Start_Time__c) + ' - ' + TEXT(Finish_Time__c), ".000", null)
This was selected as the best answer
Kieran BrayKieran Bray
Perfect - Thanks Tony