# # of Minutes between times - Need help

Options
edited 02/04/21

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?

• edited 02/04/21
Options

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?

• ✭✭✭✭✭✭
Options

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?

• Options

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

• Options

Just got an email from smart sheet and this is not possible yet. perhaps in a future release

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

@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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!