Unparseable error

I created a formula, for tracking time, and as the owner, it works really well. But when I share the sheet, no-one else is able to use this. The error message comes back as unparseable. This is the code.

fx=SUM(((TIME([Time Out]20, 0, 2) - TIME([Time In]20, 0, 2)) - [Non Billable Breaks/Mtgs.. ETC]20) * 24).

thoughts?

Find more posts tagged with

Accepted answers

All comments

Jeff Reisman

Can you explain what TIME([Time Out]20, 0, 2) does?

I don't show a TIME function anywhere in Smartsheet.

Captain Hook

Hi, I can try..

The TIME function returns the decimal number for a particular time that is entered in a different column called [Time Out]. The resulting value is in rounded to a 2 place decimal. I then use that information to process the # of hours worked in a given day.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.