LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jwy
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
elapsed time average calculcations relux Excel Discussion (Misc queries) 6 August 26th 05 07:33 PM
show elapsed time ? heathcliff Excel Discussion (Misc queries) 3 June 14th 05 09:52 PM
Calculating a rate for elapsed time? Keith Excel Discussion (Misc queries) 8 May 18th 05 09:14 PM
How to format elapsed time for swimming scores T-mo Charts and Charting in Excel 1 April 21st 05 12:26 PM
elapsed time calculation rwf Excel Discussion (Misc queries) 1 January 21st 05 04:51 AM


All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"