New answers tagged

0

You need to substract 12 if the hour is greater than 12, it means that you need an IF like this: IF (HOUR(Shift_App_Profile__r.Sunday_Preferred_Start__c) < 12, HOUR(Shift_App_Profile__r.Sunday_Preferred_Start__c), HOUR(Shift_App_Profile__r.Sunday_Preferred_Start__c) - 12) in each place you show the hour


Top 50 recent answers are included