# of Minutes between times - Need help
I'm looking for a formula to calculate the number of minutes between two times in 12 hour format (i.e. Start time - 9:00 / End time - 9:45). Are you able to assist?
Answers
-
I'm looking for a formula to calculate the number of minutes between two times in 12 hour format (i.e. Start time - 9:00 / End time - 9:45). AM and PM are separate columns from the times. Are you able to assist?
-
Will you be crossing over midnight into a different date, or will the start and end times always be within the same date? Will your start and end times always be within the same hour, or could you have a 9:00am start time and a 10:15am end time?
-
I am looking for something similar. all my times are in the same 24 day. So if I have Check in column and check out column. What would be the formula for Total time on site? When I imported to Smart sheet from Excel it broke my formula
-
Just got an email from smart sheet and this is not possible yet. perhaps in a future release
-
Hey @Ken Hoffman
You might not be able to do it in a single formula but @Paul Newcome has a compilation of 'time' formulas. Find the compilation here
-
@Ken Hoffman If you do not have to worry about dates and you are using a 24 hour format, then you can do the calculation in a single formula like so...
=INT(((VALUE(LEFT(Out@row, FIND(":", Out@row) - 1)) + (VALUE(RIGHT(Out@row, 2)) / 60)) - (VALUE(LEFT(In@row, FIND(":", In@row) - 1)) + (VALUE(RIGHT(In@row, 2)) / 60)))) + ":" + (((VALUE(LEFT(Out@row, FIND(":", Out@row) - 1)) + (VALUE(RIGHT(Out@row, 2)) / 60)) - (VALUE(LEFT(In@row, FIND(":", In@row) - 1)) + (VALUE(RIGHT(In@row, 2)) / 60))) - INT(((VALUE(LEFT(Out@row, FIND(":", Out@row) - 1)) + (VALUE(RIGHT(Out@row, 2)) / 60)) - (VALUE(LEFT(In@row, FIND(":", In@row) - 1)) + (VALUE(RIGHT(In@row, 2)) / 60))))) * 60
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!