Need Elapsed Time Help
 

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!


--
Jwy
------------------------------------------------------------------------
Jwy's Profile: http://www.excelforum.com/member.php...o&userid=27641
View this thread: http://www.excelforum.com/showthread...hreadid=471594

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)

--
Regards,
Fred


"Jwy" wrote in message
...

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!


--
Jwy
------------------------------------------------------------------------
Jwy's Profile:
http://www.excelforum.com/member.php...o&userid=27641
View this thread: http://www.excelforum.com/showthread...hreadid=471594

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


--
Jwy
------------------------------------------------------------------------
Jwy's Profile: http://www.excelforum.com/member.php...o&userid=27641
View this thread: http://www.excelforum.com/showthread...hreadid=471594