Posted to microsoft.public.excel.worksheet.functions

Jason Adolf

Posts: n/a

Subtracting Date/Time pairs

I need to subtract two dates in this format to get an elapsed time.

start time
12/15/2005 17:55

end time
12/19/2005 20:39

I would like to see it in either day decimal format (i.e 1.345 days)
or hours (55.3345 hours)

If there is a way to do this, please let me know.

jA

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
Calculating days & time left from start date/time to end date/time	marie	Excel Worksheet Functions	7	December 7th 05 02:36 PM
date/time stamp	Jan	Excel Worksheet Functions	7	July 14th 05 01:04 PM
date/time	Jan	Excel Worksheet Functions	3	June 19th 05 05:47 AM
Date/time range based calculations	jim314	Excel Discussion (Misc queries)	1	April 28th 05 07:21 PM
How do i convert a number of seconds to a date/time?	Margo	Excel Worksheet Functions	2	January 5th 05 12:09 AM

All times are GMT +1. The time now is 05:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us