Send to a Friend

augustlan's avatar

Is there an Excel formula for calculating a length of time and converting it to decimals?

Asked by augustlan (47745points) July 12th, 2013

Math hurts my brain, and I am getting tired of counting on my fingers and adding fractions. Help a jelly out?

What I need is a time-specific formula for a horizontal layout something like this:

Cell A1: I’d enter the ‘start time’ (for example, 1:15 pm)

Cell B1: I’d enter the ‘end time’ (say, 7:45 pm)

Cell C1: Here, I want it to automatically calculate the time between A1 and B1, in standard quarter hour decimals (in this case, that would be 6.5 hours).

Ideally, I’d like a formula that can do the job even when the start time is in the PM and the end time is in the AM (for example 11:45 pm to 3:30 am, which is 3.75 hours). I always round the start and end times to the nearest 15 minutes when I enter them, so rounding isn’t an issue in the formula.

PS: I did search for the formula, but couldn’t find what I’m looking for. I might just be using the wrong terms, though.

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.