set time

10/14/21
Answered - Pending Review

Hi,

=IF([email protected] = "Fast", [email protected] + 30, IF([email protected] = "Long", [email protected] + 60, IF([email protected] = "Large", [email protected] + 120, "Not Proper process Type")))

Actually i would like to do, if procees type Fast ,, add 30 min more with starttime, Long means 1 hr,Large means 2 hr,,

can anyone pls help me to fix the problem...

Thank you for your help,

Answers

  • Jason DuryeaJason Duryea ✭✭✭✭✭

    It thinks 08:00 is a text value, so isn’t adding 30 min as you’re expecting. Think this would require using a Date column type for both columns.

  • Hallo Mr. Jason, Thank you for your reply and time,,

    i tried to change the column type,, but still same problem ,,,, Is thr any other posiibility

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    There should be a solution tucked away in this thread:



    thinkspi.com

  • hi @Paul Newcome i have searched on that link but am not sure how to bind up that in my solution,,

    can you please help me..

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    There should be a solution there regarding (if I remember correctly) shifts that account for a "lunch break". That would be the base of the solution.

    thinkspi.com

Sign In or Register to comment.