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.
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.
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
Bruce
Bruce
The older I get, the better I used to be.
USA
=A2-A1, Format as [h]:mm:ss
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"scharee" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks