set time

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,

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.