You need to sign in to do that
Don't have an account?
Mohan Raj 33
why the current and setting time difference is varying to compare to the manual calculation?
I have a formula field to calculate the setting and current time value difference is using by the following formula
But in here I feel the difference in the answer by the formula and the manual calculation like as followingly,
In  case if the Calculating_Date__c value is 12/10/2016 6.20 AM and the current time is 12/10/2016 7.15 PM then the difference is coming by the formula answer is 0.20 but the manually the difference is 12.55(in hours).
So That's my question why the difference is happen and If I get to the manual calculation answer what am I do?
For Answer thanks in advance.Thank you, MohanÂ
ABS( Calculating_Date__c - NOW() )*24)
But in here I feel the difference in the answer by the formula and the manual calculation like as followingly,
In  case if the Calculating_Date__c value is 12/10/2016 6.20 AM and the current time is 12/10/2016 7.15 PM then the difference is coming by the formula answer is 0.20 but the manually the difference is 12.55(in hours).
So That's my question why the difference is happen and If I get to the manual calculation answer what am I do?
For Answer thanks in advance.Thank you, MohanÂ
ABS((Calculating_Date__c - NOW())*24)
So how to get my correct manual calculation answer and my time zone is UTC + 5.30 (india) if it is give any effect in my calculation of formula.please give the right solution of my formula.
(floor((Calculating_Date__c -  NOW())*24)) + (((((Calculating_Date__c -  NOW())*24)-floor((Calculating_Date__c -  NOW())*24))*60)/100)