Subtract them and multiply by 24 and format as general
or
Subtract them and format as [hh]:mm

=(a1-b1)*24
(formatted as general)

=a1-b1
(formatted as time)

Jithu wrote:

Hi,

Is is possible to find out the difference between two dates in Hours.

eg 4/4/2007 0.00AM and 5/4/2007 0.00AM

Difference is 24 hrs

Please sort this out...thanks in advance for the help.

--

Dave Peterson