Required completion time in hours between "dates" and in "hours and minutes"

Hello, I have two columns: Start Date and End Date. I also have Hrs, Min, and Clock available, as shown in the image below. Now I need the completion duration in hours between these dates, as well as the Hr & Min.

Thanks & Regards


SSPM Consultants

Email ID:

Did I answer to your question or fix the problem? Please help the Smartsheet Community by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!