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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"scharee" wrote in
message ...

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.


--
scharee
------------------------------------------------------------------------
scharee's Profile:
http://www.excelforum.com/member.php...o&userid=25820
View this thread: http://www.excelforum.com/showthread...hreadid=392160