Unparseable error

Captain Hook

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?

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.