Skip to Content
0
Former Member
Mar 10, 2009 at 12:16 PM

Help with Time formula

21 Views

Hi, I was hoping someone could help me. I have an age formula I need to determine based on a specific time frame. So we need to say if the time is between 8am and 1pm then the SLA is 8 hours. But if it was submitted after 1pm then the SLA is 8am the next morning. I tried using the mid function but that only works for strings. Con anyone help?