locked
Calculated Column in a List Formula RRS feed

  • Question

  • I know some basics with doing formulas but I am far from doing more advanced ones but i'm hoping somebody can help me with this... I'm trying to create a formula that will return 1 of 3 different Text answers if the time of day in a date/time column falls between a certain time... Basically I want...

    If [Date and Time Colum] is >= 4:30am and <= 9:00am then return text "Morning"

    If [Date and Time Colum] is >= 10:30am and <= 12:00pm then return text "Mid"

    If [Date and Time Colum] is >= 1:30pm and <= 5:00pm then return text "Afternoon"

    If [Date and Time Colum] is = Other then reutrn text "Other"

    Help would be greatly appcreciated!!!!

    

    Thursday, January 22, 2015 2:50 PM

All replies