Posted to microsoft.public.excel.worksheet.functions

stumped

external usenet poster

Posts: 37

date and time difference

A | B | C | D |
E
1| 12/09/04 | 3:45 PM | 05/15/06 | 1:00 AM |
2|
3|
4|
5|

Log for short and long term visits. Colums A&B being start date and time in
that format Colums C&D being end date and time.
Need E1 to = total duration in Format YY/MM/DD HH:MM
And E5 to = total of E1:E4 in the Format YY/MM/DD HH:MM
Please help, been at this problem for weeks now.

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
Date/time difference	Caroline	Excel Worksheet Functions	4	September 12th 09 02:17 PM
Date time difference	JMB	Excel Discussion (Misc queries)	5	March 12th 08 10:47 PM
date and time difference	vito	Excel Worksheet Functions	8	August 10th 07 06:58 PM
Difference in date and time	Arun2902	Excel Discussion (Misc queries)	0	March 9th 07 03:17 PM
Calculating Difference Between Start Date & Time And End Date & Ti	Samwar	Excel Discussion (Misc queries)	2	December 19th 05 12:42 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us