both numbers come out to EXACTLY 20 minutes and 0 seconds, which is the
correct answer. What kind of precision are you looking for? Nanoseconds?

"KC" wrote:

consider below data which has two datetime with 20 mins difference
A
1 16-02-10 5:32:34 AM
2 16-02-10 5:52:34 AM
3 0.0138888888905058

where A3 has a formula A2-A1 (as general format), can someone please explain
how this fraction value is derived?

based on my understanding if i convert 20 mins (which is 1200 sec) in terms
of days.
i.e., 1200/(60*60*24) = 0.0138888888888889

which is close to A3 but not exactly same! I need to know a way to exactly
calculate the fraction value that date difference generate.

any help is highly appreciated!
thanks
-kc