Help with Time formula

[Former Member]

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?

[Former Member · Accepted solution]

Have you tried using Hour function?

[Former Member · Accepted solution]

Hi ,

Are you using stored procesure to genrate this report? Please let me know I will give you soluation.

Thanks ,

Manjunath Jogin

[Former Member · Accepted solution]

Thank you I completely forgot!

[Former Member · Accepted solution]

Hi ,

Are you using stored procesure to genrate this report? Please let me know I will give you soluation.

Thanks ,

Manjunath Jogin

[Former Member]

Hi Kemberly,

You can use Hour() function to check this

If Hour({YourTimeField) > 8AM and Hour({YourTimeField) < 1PM

Then Hour({YourTimeField) + 8

else

if Hour({YourTimeField) > 1PM Then

Hour({YourTimeField)+20 (this needs to be calculated based on the submission time)

Thanks,

Sastry