I am calculating formula to get difference between to date/time fields. But in minutes section it always shows 1 minute less or sometimes 1 min extra.
Example if Start Time- 08.06.2018 09:28 End Time- 08.06.2018 10:38 then difference coming as 0 Days 1 Hours 9 Mins Whereas it should be 10 Min.
I am simply lost from many days. This works fine with my developer org but not in the sandbox. Can anyone please help?
TEXT(ROUND(MOD((ClosedTimestamp__c - OpenedTimestamp__c)*1440,60),0))