2 Replies Latest reply on Aug 14, 2011 1:56 PM by DanaStites

    If Calculation with Time



      If Calculation with Time


       I need a calculation that will find times (6pm - 11pm) and return a text result "prime"; find (6am-5:59pm) and return a text result "daypart"; everything else (11:01p-5:59am) "overnight"

      It appears FMP calculates times by seconds, so it may need to look more like this: > 64799 < 82801; but I cant get it to accept a range of data > < 

      Any ideas?