# Tracking Hours of Effort

Options

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!

• Employee
Options

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

October 8 - 10, Seattle, WA | Register now

• Employee
Options

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

October 8 - 10, Seattle, WA | Register now

• Options

Thanks, Genevieve...much appreciated!

• Options

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

• Employee
Options

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