(NOTE: HERE WE TAKE ONE EXAMPLE FOR FINDING TOTAL TIME)
* CREATE ONE CUSTOM OBJECT AS TIME ENTRIES
* ON TIME ENTRIES OBJECT CREATE TWO FIELDS AS START TIME AND END TIME USING FIELD TYPE TIME
* NEXT, TO CREATE ANOTHER FIELD AS TOTAL TIME USING FORMULA FIELD
*AND IN FORMULA CHOOSE FORMULA RETURN TYPE AS NUMBER WITH 2 DECIMAL PLACES
* AND GIVE THE BELOW FORMULA IN THE ADAVNCED FORMULA AREA
( HOUR(END_TIME__c) - HOUR(START_TIME__c)) + (( MINUTE( END_TIME__c ) - MINUTE( START_TIME__c ))/60)
* CHECK WITH SYNTAX ERROR AND SAVE THE FIELD
* NOW GO BACK TO TIME ENTRIES IN APP LAUNCHER
* CREATE NEW TIME ENTRIES BY SELECT NEW
* THEN GIVE START TIME AND END TIME VALUE AND CLICK SAVE
* NOW YOU GET TOTAL TIME ON THE RECORD PAGE
!!!!!THANK YOU FOR VISTING MY WEBSITE!!!!!!
No comments:
Post a Comment