# 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
Check out the Formula Handbook template!