Tracking Hours of Effort

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!

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!