Need help calculating Time (New to Smartsheet Formulas)
Hi all - I've searched and read through various questions/ responses regarding Time calculations and have come to the realization that I need help.
I have a Start Time and End Time (Start & End of Trainings) - I used a dropdown from 07:00 to 23:30 (We typically train within business hours 8a-5p EST - but every so often there is one that is is at 7 am or after hours ).
Column Name: Start Date (Column Type: DATE)
Column Name: End Date (Column Type: DATE)
Column Name: Start Time (EST) (Column Type: Single Select Dropdown)
Column Name: End Time (EST) (Column Type: Single Select Dropdown)
I would like to have the following columns calculated:
Duration (Hours) & Duration (Minutes)
I was able to create a NetworkDays formula & Minutes but it's not accurate data as it does not take into account actual hours trained (some training are 3.5 hrs etc..) I would LOVE the duration auto-calculated vs manually adding duration to obtain the data..
Any thoughts on how to go about this - changes I should make to my existing columns?
Help Article Resources
Check out the Formula Handbook template!