set time

PYI

Hi,

=IF(Processtype@row = "Fast", Starttime@row + 30, IF(Processtype@row = "Long", Starttime@row + 60, IF(Processtype@row = "Large", Starttime@row + 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,

Jason 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.

PYI

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 Newcome

There should be a solution tucked away in this thread:

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

PYI

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 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.