Need Elapsed Time Help

[Jwy]

I'm looking for a simple way to calculate the elasped time between two
dates. I tried the code from the MS site, but felt the result was not
what I was looking for.

I need to see in days/hours elapsed time between two dates. For
instance, if cell A1 has a date/time stamp of 9/28/05 10:00 AM and cell
A2 has a date/time stamp of 9/29/05 11:30 AM, the result should be 1 day
1.5 hours.

Can this be done? All help is appreciated.

Thanks!

 

[Fred Smith]

It can be done easily. Just subtract the two cells, as in:

=a2-a1

Format the result the way you want (eg, dd hh:mm:ss)

 

[Jwy]

...never mind, found what I was looking for after searching the list.
:rolleyes