Calculating time in Minutes in Smartsheet

jeromejohn

How do I calculate time in minutes? I imported an excel sheet, but got a invalid error. Please help.

Pamela Clapp

Here are a couple links that might help that have been posted by @Paul Newcome

https://community.smartsheet.com/discussion/79427/calculating-time-in-hh-mm-ss

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

jeromejohn

@Pamela Clapp Thank you for the quick response. The results shows hours minutes and seconds with complicated formula. I am looking for a specific formula to calculate time in minutes given the start time and end time.

ker9

@jeromejohn - does your time span days?

This new function might help you:

https://community.smartsheet.com/discussion/110711/new-time-function-for-formulas

Monique Odom-Stearn

Hello @jeromejohn,

Try something like this using the TIME function @ker9 mentioned:

=(TIME([End Time]@row)-TIME([Start Time]@row))*24*60