Difference between two dates
 

1 represents 24 hours...

Excel has precision upto 15 places of decimal which might explain the
difference.

"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