Multiple time (in hours) worked by number of weeks worked

Jeffrey Benford

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.

 

 

 

Shaine Greenwood

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!