You need to sign in to do that
Don't have an account?
Lakis
Convert TEXT to hours and minutes
Hey guys!
I'm not sure if I'm not overcomplicating this but... here it is:
I have a picklist with hh:mm values to represent time difference such as -:1:00 or +1:00.
As a part of the improvement to countries selection (separate country from time difference), I'm trying to calculate "Current Time at Location" based on the picklist value.
So far, I'm converting picklist to TEXT, using formula field "UTC Time Picklist to TEXT" so that I can use it in my calculation. However, I'm strugling to convert "UTC Time Picklist to TEXT" into hh:mm using Date/Time formula field so that I can use it for time calculation.
Would it be possible at all? For the "Current Time at Location" calculation I'm using:
TIMENOW() + VALUE( TEXT(UTC_TEXT_to_TIME__c ))
Assisting secreenshot attached. Many thanks for any ideas!
Lakis
I'm not sure if I'm not overcomplicating this but... here it is:
I have a picklist with hh:mm values to represent time difference such as -:1:00 or +1:00.
As a part of the improvement to countries selection (separate country from time difference), I'm trying to calculate "Current Time at Location" based on the picklist value.
So far, I'm converting picklist to TEXT, using formula field "UTC Time Picklist to TEXT" so that I can use it in my calculation. However, I'm strugling to convert "UTC Time Picklist to TEXT" into hh:mm using Date/Time formula field so that I can use it for time calculation.
Would it be possible at all? For the "Current Time at Location" calculation I'm using:
TIMENOW() + VALUE( TEXT(UTC_TEXT_to_TIME__c ))
Assisting secreenshot attached. Many thanks for any ideas!
Lakis