How do I join a date and time that are in separate columns?

Posted to microsoft.public.excel.misc

jenn

external usenet poster

Posts: 107

How do I join a date and time that are in separate columns?

Thanks for your quick reply that is great

"Mike H" wrote:

Jen,

Try:

=(C1&D1)-(A1&B1)

c1 d1 are the later date and time
a1 b1 are the earlier.

Mike

"jenn" wrote:

I want to calculate the difference between two dates and times but my date
and time colums are separate. Is there an easy way to join them.

Thanks

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
Elapsed time when separate cells contain time and separate date	Gnugs	New Users to Excel	1	March 7th 07 08:48 AM
Merging separate date and time columns into one	Gadgets	Excel Discussion (Misc queries)	5	July 26th 06 09:24 PM
Combined date time cell to separate date & time components	Mark Ada	Excel Discussion (Misc queries)	1	December 2nd 04 02:48 AM
Combined date time cell to separate date & time components	Mark Ada	Excel Discussion (Misc queries)	1	December 2nd 04 12:07 AM
Combined date time cell to separate date & time components	Mark Ada	Excel Worksheet Functions	1	December 2nd 04 12:04 AM

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

Menu

About Us