# of Minutes between times - Need help

Deb Harrison

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?

Deb Harrison

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?

Paul Newcome

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?

Ken Hoffman

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

Ken Hoffman

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

Kelly Moore

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

Paul Newcome

@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