Calculating time in Minutes in Smartsheet
How do I calculate time in minutes? I imported an excel sheet, but got a invalid error. Please help.
Answers
-
-
@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.
-
-
Hello @jeromejohn,
Try something like this using the TIME function @ker9 mentioned:
=(TIME([End Time]@row)-TIME([Start Time]@row))*24*60
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Monique Odom-Stearn
Business Process Excellence Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!