Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Multiple time (in hours) worked by number of weeks worked
Hi All,
I am almost done building a sheet that will show:
1) Time worked per day
2) Time worked over the course of weeks
The formula computing the duration or #1, shows the computation in time hours; for example,
StartTime Column reads: 12:00pm
EndTime column reads: 4:00pm
WkHours column reads: 4:00
To get total hours of time worked a set number of weeks, I added a WksInTerm column. The problem is that this formula: =SUM[(DayHours1) * (WksInTerm1)] results in #UNPARSE error message, but I want the TermHours to show the accurate result of muliplying WksHours and geting an outrcome of -- 72.
Please help.
Comments
-
Hi Jeffrey,
Currently, Smartsheet doesn't support time values (hh:mm:ss) or caluclations thereon, so keep that in mind when crafting your formula. You might have to get clever with picking the value out, converting it to a decimal, then calculating on that instead.
Right off the bat, your formula syntax won't work in Smartsheet, hence your #UNPARSEABLE error. Check out our Help Center to see what formula syntax in Smartsheet looks like: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet
You might also check out our list of available functions to see if you can develop a workaround for caluclating on the values you need: https://help.smartsheet.com/articles/775363-using-formulas
If you find a solution that can benefit others, feel free to post it as a reply!
