Steve M via OfficeKB.com

Posts: n/a

Elapsed time in days

Cell A1 is Jan 1, 2005 0:00
Cell A2 is Feb 28, 2005 00:00

I want cell A3 to calculate the elapsed time in days shown as "58:00:00".
How do I format cell A3?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Format elapsed time in days?	Steve M via OfficeKB.com	Excel Worksheet Functions	2	August 5th 05 09:28 PM
elapsed time calculation	rwf	Excel Discussion (Misc queries)	1	January 21st 05 04:51 AM
Elapsed time Calc...over 30 days long...	[email protected]	Excel Discussion (Misc queries)	1	December 6th 04 06:16 PM
Elapsed time Calc...over 30 days long...	[email protected]	Excel Discussion (Misc queries)	1	December 6th 04 05:39 PM
Elapsed time Calc...over 30 days long...	[email protected]	Excel Discussion (Misc queries)	0	December 6th 04 05:27 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us