Time Difference Calculation Using Military Time

lorena_uzin

I am struggling coming up with a time difference calculation smartsheet.

I have two text fields, one called From and the other To. Users are to input time in a military format (exp: 07:00, 13:00) and then the calculation should fill my Duration field with the difference between those two times.

Can this be done without date columns? Seems simple enough but I have no luck as of yet.

Paul Newcome

If the end time will always be on the same day as the start time, you would use something along the lines of

=(TIME(From@row) - TIME(To@row)) * 24

lorena_uzin

Awesome, thank you for that.

I finally have a calculation but although these time ranges will always fall within the same day, the calculation reads weird for the minutes. For example: 08:03 - 09:10, the Duration column reads 1.11667.

Can you help with this?

Paul Newcome

@lorena_uzin Try this:

=INT((TIME(From@row) - TIME(To@row)) * 24) + ":" + ((((TIME(From@row) - TIME(To@row)) * 24) - (TIME(From@row) - TIME(To@row)) * 24) * 60)