AnsweredAssumed Answered

Time calculation

Question asked by yomango on Jun 18, 2012
Latest reply on Jun 18, 2012 by yomango

Title

Time calculation

Post

Hi, out there. I have a start time, time field. I have 5 networks that have different peak/off peak hours. When I get each network report I´d like to know, through a calculating field,  if the start time is a peak or an off peak hour. For intance, from 7 to 20 hours is Peak for some networks, for others the peak hours are between 7 and 19 hours. I´ve use the Case and If functions with AND/OR operands but they do not work all the time, if I get right the Peak hours, my Odd Peak hours get messed up and viceversa. The fields are: start_time (time field) and the network field (text field). Any one out there than can help. I will really appreciate your help.

Outcomes