OK...
how to do if both the dates happen to be same

eg eg 4/4/2007 0.00AM and 4/4/2007 1.00AM ...

i want the time difference as I hour

"Mike H" wrote:

Maybe

=(B1-A1)*24

Where A1 is the earlier date/time. Format as general

Mike

"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.