Calculate Difference b/e 2 dates.

[scharee]

How can i calculate difference b/w two dates:
Date1 Date2
30-JUL-2005 23:43:23 01-AUG-2005 18:10:01

Result format should be Hours:Minutes:Seconds

 

[swatsp0p]

Assuming your dates are in A1 and A2, in A3 enter this formula:

=A2-A1 and format this cell as Custom>[h]:mm:ss

Your example returns: 42:26:38

HTH

Bruc

 

[Niek Otten]

=A2-A1, Format as [h]:mm:ss

--
Kind regards,

Niek Otten

Microsoft MVP - Excel