Posted to microsoft.public.excel.misc

Tstewart14 Tstewart14 is offline

external usenet poster

Posts: 1

Subtracting Times with dates

I have 4 colums on for start date one for start time one for end date and one
for end time

I need to find a formula that will give me just the difference in the two
times they may be two to 3 days different in the dates. example 3/1/2010
14:30 3/3/2010 22:30 need it to give me the answer of 56:00

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
Subtracting Times	[email protected]	Excel Worksheet Functions	2	February 19th 07 04:47 PM
Adding/Subtracting Dates & Times	Kim17740	Excel Worksheet Functions	2	April 12th 06 01:04 AM
Subtracting times	gaftalik	Excel Discussion (Misc queries)	3	November 2nd 05 06:45 PM
Subtracting Times	NChris	Excel Worksheet Functions	1	February 10th 05 09:29 PM
Subtracting times	[email protected]	Excel Discussion (Misc queries)	1	January 12th 05 09:55 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us