Quote:
Originally Posted by Longhorn1972
I need to know how to find the difference in time in two cells with a
date/time format of 05/01 04:30
|
If A1 has:1/1/2010 5:05:00 AM
B1 has 10/10/2010 12:02:00 PM
this formulae
="days- "&TRUNC(B1-A1,0)&" hours-"&(((B1-A1)-TRUNC(B1-A1,0))*24)
gives u the result as:
days- 282 hours- 6.94999999995343
all the best