Help automating a duration

Scott Kirn

I have 2 check box columns one is Start time one is stop time, how can i create a formula to pull the duration in hours between when start and stop are checked? I have automated to capture the date when box is checked but i really need the time in hours.

Darren Mullen

@Scott Kirn Do you have access to Smartsheet Bridge, that's the only reliable way I can think of to do it with Smartsheet tools. Otherwise you'd need a 3rd party service or script to get the time when the boxes are checked since Smartsheet can't timestamp.