You need to sign in to do that
Don't have an account?
iqbal
Subtract Date/Time fields
Hi,
I created a formula field of type number which subtracts two date/time fields and i am getting strange result when two values are subtracted.
(12/24/2009 3:05 PM) - (12/24/2009 12:05 PM) is giving me 0.1250
I basically want to calculate difference between two date/time fields and i expect the difference to be in terms of 'days-months-hours-minutes'.
Has anyone faced this problem? If not with formula field, is there any other way to achieve this.?
thanks,
Asif
Steve :-/
The result that is being displayed is the difference in Days: 3 Hours = 0.125 Days. What exactly do you want you formula to display? the time? just hours? HH:MM? HH:MM.SS?
iqbal
Thanks for your reply. HH:MM is good for me.