3139 Shares

# How do I take two recorded times and write a Microsoft Excel formula that calculates the total time?

Topic: How to write am pm times
July 15, 2019 / By Brier
Question: If I have beginning and end times recorded in a Microsoft Excel Spreadsheet, how can I create a formula that calculates the amount of time between the beginning and end times? When I add, say 9:45 PM and 10:05 PM, it tells me that the answer is 7:50 PM. Is this because I have my time cells formatted to hh:mm AM/PM? I had assumed auto sum would give me an answer instantly, be it doesn't seem to accomplish what I'm asking it to. I want it to fill the SUM cell with something along the lines of 20 min.

## Best Answers: How do I take two recorded times and write a Microsoft Excel formula that calculates the total time?

Aliah | 7 days ago
A1 is start, B1 is finish, C1 =IF(A1>B1,(1+B1)-A1,B1-A1) format the cell as [h]:mm To sum a series of times just use the SUM function but format the result cell using the above format.
👍 222 | 👎 7
Did you like the answer? How do I take two recorded times and write a Microsoft Excel formula that calculates the total time? Share with your friends

We found more questions related to the topic: How to write am pm times

Originally Answered: Is there a Microsoft Excel formula that can look up the following?
ok, you can use the sumproduct() formula lets say this data starts in cell A1, with column A being the letters to cell A8 and the numbers start in cell B1 and ends in B8 you want to count all the A's that have the 2's next to them...for now. it looks like the answer should be 2, in this case the 1st line and the 3rd line. do you want that to by dynamic(cell references)? or do you want A and 2 hardcoded into the formula? try this: - in cell C1 type the letter A - in cell D1 type the number 2 - in cell E1 copy&paste this formula =SUMPRODUCT((A1:A8=C1)*(B1:B8=D1)) this will give you the answer 2 as a test: - you can change C1 and D1 randomly to find other random combo's - change cells in column A and B randomly if you want the A and the 2 hardcoded in the formula, then =SUMPRODUCT((A1:A8="A")*(B1:B8=2)) remember, its a sumproduct, so you have to define a table range, and they both have to be the same size...so even large ranges like A1:A2567 and B1:B2567 will work. but you cant use the entire column A:A and B:B... enjoy edit- in this case...the F1 key for sumproduct() is correct, but does not help (take a look at it). you really have to google it. the formula above does multiply the components and adds them up. if a condition(and the formula has 2 conditions for each row) is true=1 if false=0, then it multiplies the 1*1=1 or the 1*0=0 and adds them up.
Originally Answered: Is there a Microsoft Excel formula that can look up the following?
You need to become familiar with CSE formulas...without a long explanation here, you need to be able to in effect use "count if" with two different parameters. This is called an array formula, and it's a little tricky. You need to hold control and shift after entering the formula in the formula bar while pressing enter - this will put { } around your syntax and give you what you want. Try the below links for more info...

Tyrone
Take the two times, select the two cells they are in. Go to SUM in the list of functions. It will give you the total.
👍 90 | 👎 -2

Rik
A humorous one and that i provide you a large call. right here's a humorous(!!) ghosts chat. 2 ghosts met and the two chat approximately how they died. 1st ghost : How u died? 2d ghost : I died of chilly. 1st ghost : How does it sense once you're death in chilly? 2d ghost : easily, i develop into by probability locked in the refrigerator. initially, i develop into shivering, then my comprehensive physique began to freeze, later I felt the comprehensive international develop into dark and that i died suffocating. 1st ghost : Wow what a terrible thank you to die.... 2d ghost : How approximately you? How u die? 1st ghost : I died from coronary heart attack. 2d ghost : I see, why did u have a coronary heart attack? 1st ghost : easily, i found out that my spouse is having an affair with yet another guy. sooner or later, once I got here back from paintings, observed a pair of guy shoes outdoors my residing house. Then, i found out that the guy develop into in my residing house with my spouse. once I rushed into the mattress room, my spouse develop into on my own. i'd desire to discover the place that bastard is hiding. So I searched the rest room, I ran downstairs, regarded in the storeroom, however the bastard develop into no longer there. So, I ran upstairs and searched the cloth cabinet, yet i stumbled on no longer something. using fact of all that working,I have been given a coronary heart attack and died. 2d ghost : Why you under no circumstances seek for the bastard in the refrigerator? The bastard develop into hiding there. We the two could be alive now!!
👍 84 | 👎 -11

Originally Answered: Time scale on time series analysis in microsoft excel?