AnsweredAssumed Answered

If Calculation with Time

Question asked by DanaStites on Aug 13, 2011
Latest reply on Aug 14, 2011 by DanaStites


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?