My formula field calculation of the difference of calculation date(date/time field) and current date(date/time field).
But it is differentiated in the manual calculation answer.
ABS( Calculating_Date__c - NOW() )*24)
Above the formula is there to be used to calculate the time difference of Calculating_Date__c and current time.
But 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).
why this difference.and how to get the correct value.
For answers thanks in advance.