=NETDAYS

Options

I keep getting an error message:

I am trying to set the duration between when approval to close and approval to open but in hours and minutes.

When I referenced the Sheet to {Approver Time Stamp Open} I only chose the one column.

=NETDAYS([Approver Time Stamp Close]@row, {Approver Time Stamp Open}@row)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!