Huge thanks to all! Using a combination of ideas from you, here is what I
used (in case anyone wants to know):
Formula field 1: AM/PM =
if Time({Times__eSight.Start})< Time(12,00,00) then "AM"
else "PM"
Formula field 2: Day =
DayOfWeek ({Times__eSight.Start})
Formula field 3: Day/Shift =
~~~~~~~~~~~~~~~~~~~~~
if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = "PM" or [EMAIL PROTECTED] and
[EMAIL PROTECTED]/PM} ="AM") then "S-M
Shift" else
if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = "PM" or [EMAIL PROTECTED] and
[EMAIL PROTECTED]/PM} ="AM") then "M-T
Shift" else
if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = "PM" or [EMAIL PROTECTED] and
[EMAIL PROTECTED]/PM} ="AM") then "T-W
Shift" else
if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = "PM" or [EMAIL PROTECTED] and
[EMAIL PROTECTED]/PM} ="AM") then "W-T
Shift" else
if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = "PM" or [EMAIL PROTECTED] and
[EMAIL PROTECTED]/PM} ="AM") then "T-F
Shift"
~~~~~~~~~~~~~~~~~~~~~
Then I was able to group by Day/Shift, which gave me everything I needed!
Huge thanks to all again!!!
Shawn
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
