Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 46

Tricky IF/Then Date based formula needed

Column A has the date and time displayed: Thu, 06/14/07, 11:15
Column B needs to calculate: "If (A=Mon to Fri from 7:00 to 20:00, Sat from
7:00 to 15:00, Sun from 7:00 to 16:00 Then Display in Column B "On Time")
If False then Display in Column B "Closure Time")

I don't even know where to start with this one. Any assistance would
certainly be appreciated. Thanks in advance for your help.

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
Tricky Date calculation: How to calculate a future date	[email protected]	Excel Discussion (Misc queries)	9	August 11th 06 04:24 AM
Date formula needed	Rich Hayes	Excel Worksheet Functions	4	December 9th 05 07:25 PM
Date stamp formula results? Tricky problem?	mjp	Excel Discussion (Misc queries)	0	November 18th 05 04:11 PM
Date formula needed	VDan	Excel Discussion (Misc queries)	4	August 31st 05 04:01 PM
Tricky formulas needed	Myrna Larson	Excel Worksheet Functions	2	October 29th 04 03:29 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us