Thread
:
Tricky IF/Then Date based formula needed
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
Titanium
external usenet poster
Posts: 46
Tricky IF/Then Date based formula needed
Thanks so much for your reply!
"Don Guillett" wrote:
First, Look at the AND function. Then,the OR function and then the IF
function. Put together in that order.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Titanium" wrote in message
...
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
Titanium
View Public Profile
Find all posts by Titanium