Formulas for Calculating Time

@L@123 Thanks for the addition! Looks like we were both working on some time based solutions at the same time. Haha.

I agree. Using the decimal makes it MUCH more straightforward. Even if the entries were stored as text values it would be as simple as a VALUE function tucked into a few spots.

The only thing I would have done differently would be to have used an INT function instead of ROUNDDOWN, but that is strictly personal preference. I always forget about the ROUNDDOWN function plus INT is less typing. Haha

I can see how ROUNDDOWN would be a little easier to understand for those that are less familiar. I hadn't thought about it that way. Haha.

Either way... Decimals instead of colons make life MUCH easier. I may start incorporating that into future solutions where we first use a VALUE/SUBSTITUTE to replace the colon with a decimal before running any further calculations.

@Ray B Exactly which one are you looking for?

@Ray B There are a handful of examples published in the original post as well as an extra one or two scattered throughout the comments. The exact one you need is going to depend on your details.

All of the links I have provided throughout this thread have all formulas and notes spelled out. Take a look at them, and you should see test/example rows as well as rows that contain text that can be very easily copy/pasted into your own sheet(s).