Tracking Hours of Effort

Glenn DeMedeiros

I have a column that tracks Actual Start date and a second column that tracks Actual Finish date. I need a formula to track Hours of Effort. Considering each day has 8-hour period, what would be the best formula to add to Hours of Effort column? Thanks!

Genevieve P.

Hi Glenn,

You could use the NETORKDAYS function to count the days from Start to End (not including weekends) then multiply this number by 8 to calculate the hours.

Try this:

=(NETWORKDAYS([Actual Start Date]@row, [Actual Finish Date]@row) * 8)

Keep in mind that the names [in these] must match your column names exactly. Let me know if this works for you!

Cheers,

Genevieve

Genevieve P.

Hi Glenn,

You could use the NETORKDAYS function to count the days from Start to End (not including weekends) then multiply this number by 8 to calculate the hours.

Try this:

=(NETWORKDAYS([Actual Start Date]@row, [Actual Finish Date]@row) * 8)

Keep in mind that the names [in these] must match your column names exactly. Let me know if this works for you!

Cheers,

Genevieve

Glenn DeMedeiros

Thanks, Genevieve...much appreciated!

Perspect

Does Smartsheet have the ability to simply add the hrs of effort available for a task? (especially when it is a fixed-price project)

I see we can add duration - which is useful for planning your schedule but not very helpful in tracking actual hrs versus planned hours (hence margin on the project)

Thanks

Genevieve P.

Hi @Perspect

You can add hours into the Duration column (see: Work with Duration and Predecessors)

However if you're looking to track hours and resources, I would recommend using Resource Management and connect your sheet with the Resource Management Panel.

Cheers,

Genevieve

Perspect

hmmm

These are very different attributes and we want to track both as the duration drives predecessors - whereas effort drives budget and resourcing