Calculating hours:minutes from cells with date and time

Mommaduck
Mommaduck ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Trying to calculate total time (preferably in minutes) spent at a task/site.

Arrival and departure "times" are written in date-time format - so (arrival) [2/28/19 9:15PM] in one cell/column and (departure) [3/1/19 2:25PM] in another cell/column. 

If it helps, those cells were created by combining multiple columns - date +hour+minute+AM/PM 

Suggestions please?  Non data geek asking this question so please, explanations in non-geek greatly appreciated!

«1

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!