Posted to microsoft.public.excel.worksheet.functions

Kim17740

Posts: n/a

Adding/Subtracting Dates & Times

Here's the setup:

A1=Date Received (formatted m/d/yyyy hh:mm)
B2=Date Sent (formatted m/d/yyyy hh:mm)
C2=Turnaround Time

I need a formula in C2 that will give me the turnaround time in d:hh:mm.

Please let me know if I need to adjust the formatting in A1 & A2.

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
formula to add dates.	S S	Excel Worksheet Functions	8	April 5th 06 07:53 PM
Pivot table dates not times	Vass	Excel Worksheet Functions	4	March 14th 06 01:15 AM
need to convert list of dates to count no. of dates by week	neowok	Excel Worksheet Functions	13	January 30th 06 03:54 PM
Autoformat dates and times	a_ryan1972	Excel Discussion (Misc queries)	5	August 1st 05 10:52 PM
Times and Dates	rob1972	Excel Discussion (Misc queries)	0	March 7th 05 04:40 AM

All times are GMT +1. The time now is 08:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us