How To Add Am And Pm Time In Excel

In that location are several functions in Excel that deal with time. However, there is no special role for calculating the departure between two times variables. While you may know, a time value is a numeric value that is represented as time, subtracting ane value from some other produces a decimal number, which must be structured as time again. In this tutorial, we'll show y'all how to calculate the time difference between AM and PM in Excel by applying formulas.

Download Exercise Workbook

Download this practise workbook to practice while yous are reading this article.

vi Means to Calculate Time Difference Betwixt AM and PM in Excel

We'll go through six dissimilar approaches to compute the fourth dimension difference in the sections below. We estimated the time departure in a variety of units, including hours, minutes, seconds, and likewise for negative values. A sample Data set is provided to practice the job.

1. Use Formula to Summate Time Difference Betwixt AM and PM in Hours and Minutes

Follow the instructions below to determine the time difference in hours and minutes.

Step ane:

To subtract the difference from end time to starting time fourth dimension, type the following formula in jail cell D5.

Step 2:

Press Enter.

Step 3:

AutoFill the rest cells with the aforementioned formula and get the terminal results.

Notes. Wait carefully that the difference is shown in AM/PM units. But, if you want to show it but the time difference with hours/minutes, you need to alter the format. To change the format follow the process.

Step 1:

Press Ctrl + ane to open the Format cells dialog box.
Click on the Time selection and select the Format as shown in the image below.
Finally, click on OK.

Therefore, the time difference will exist shown in hh:mm.

Read More: How to Calculate Fourth dimension Deviation in Excel (13 Ways)

2. Calculate Time Deviation Between AM and PM in Hours in Numbers by Applying Formula

The fourth dimension difference is usually formatted as the Time format. We can't summate the difference in hours in decimal numbers in this format. Every bit a effect, you must change the format to the Number format. Follow these easy steps to consummate the task.

Footstep i:

Firstly, type the formula in prison cell D4.

Step two:

From the Number tab, select the Number.

Step three:

Therefore, you will find the hours will be inverse to decimal numbers.

Step 4:

Repeat the procedure for all cells in the column.

Read More: Timesheet Formula in Excel (5 Examples)

3. Utilize the INT function to Calculate Time Difference Between AM and PM in Completed Hours

For counting the fourth dimension departure in a marginal figure we volition apply the INT function with the previous method. Follow the steps outlined below to get it washed.

Step ane:

Firstly, enter the post-obit formula.

Step ii:

Then, press the Enter.

Step 3:

Apply the AutoFill handle tool to make full up the required cells.

Read More than: How to Calculate Time in Excel (xvi Possible Means)

Similar Readings:

How to Calculate Elapsed Time in Excel (viii Means)
How to Add together Hours to Time in Excel (8 Quick Ways)
Excel Formula To Calculate Time Worked
How to Add Time in Excel Over 24 Hours (iv ways)
Excel Timesheet Formula with Lunch Interruption (3 Examples)

four. Use Formula to Calculate Time Departure Between AM and PM in Minutes

Nosotros need to multiply the hour by 1440 to become the fourth dimension difference in minutes. Follow the steps outlined beneath to encounter how we did it.

Step 1:

To summate in minutes, write the formula in the formula bar.

Footstep 2:

And then, printing Enter to the first result.

Pace iii:

Finally, fill up up the required cells applying the same.

Notes. Retrieve that the tome Format has to be in the Number format.

Read More: How to Add Minutes to Time in Excel (5 Piece of cake Means)

5. Apply Formula to Get Fourth dimension Difference Betwixt AM and PM in Seconds

Additionally. we take to multiply the hours past 86400 to get the hours minutes. Follow the instructions below to get the answers in the unit of seconds.

Step 1:

At commencement, type the formula in cell D5.

Stride 2:

So, to see the issue press Enter.

Step iii:

Therefore, repeat the steps again to make full upwardly the required cells.

Related Content: How to Calculate Difference Between 2 Dates and Times in Excel

vi. Use the IF Function to Calculate Fourth dimension Difference Between AM and PM for Negative Value

Importantly, the previous formulas won't work if the terminate fourth dimension is less than the get-go time. So, nosotros volition apply the conditional office IF. Follow the steps to know how to use it.

Stride i:

First of all, write the following formula.

=IF(C5>B5,C5-B5, (1-B5+C5))

Step two:

Secondly, press Enter to run into the value.

Step 3:

Finally, fill upward the cells you need.

Notes. Adding 1 means to add together 24 hours in decimal betoken. By adding 1, nosotros catechumen the negative with a positive interval.

Read More: How to Subtract and Brandish Negative Time in Excel (3 Methods)

Conclusion

To recap, I hope this tutorial has given you a solid understanding of how to calculate the fourth dimension difference between AM and PM in Excel by applying formulas. All of these techniques should be learned and used on your information. Examine the practice book and put your newfound knowledge to use. Because of your vital support, nosotros're motivated to continue developing classes like these.

Delight do not hesitate to contact us if you have any questions. Please let u.s.a. know what you lot think in the comments surface area below.

The Exceldemy Squad volition constantly reply to your questions.

Stay with usa and keep learning.

How to Subtract Military Fourth dimension in Excel (three Methods)
Calculate Hourly Rate in Excel (2 Quick Methods)
How to Summate Turnaround Time in Excel (iv Ways)
Calculate Product per Hour in Excel (iv Ways)
How to Summate Wheel Time in Excel (seven Examples)