+ Start a Discussion
Sam MalhotraSam Malhotra 

Formula apply

Hello!!
In first field user will enter a time and second field will be picklist with value CST,MST,PST,IST according to user entered time, the four other  fields should be populated with CST time Value, PST time Value,MST time value and IST time value in formula..
Best Answer chosen by Sam Malhotra
Dhanya NDhanya N
Hi Sam,

Refer this link : https://salesforce.stackexchange.com/questions/153205/convert-gmt-time-to-ist-using-formula-field . This link will be helpful for you. Here it is converting GMT to IST, same way you can try converting GMT to CST, MST, PST.

Thanks,
Dhanya

All Answers

Dhanya NDhanya N
Hi Sam,

Refer this link : https://salesforce.stackexchange.com/questions/153205/convert-gmt-time-to-ist-using-formula-field . This link will be helpful for you. Here it is converting GMT to IST, same way you can try converting GMT to CST, MST, PST.

Thanks,
Dhanya
This was selected as the best answer
satya aryasatya arya
You can add time to a datetime as fractionof day. To add hours and minutes in a formula add a certain number of 1/1440 of a day (24*60 = 1440)

Looking for a voluntarily position to sharpen my Salesforce skills. I am Microsoft.net 15 years professionl
Sam MalhotraSam Malhotra
Thank you... Dhanya N
This Link is Helpful to solve this...