How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
rate
How to Calculate Time in Excel.
rate

How to Calculate Time in Excel.

Rosemary Njeri

Time is the indefinite continued progress of existence and events that occur in an apparently irreversible succession from the past, through the present, into the future.

We measure time using clocks.

Formula to calculate time.

If the time involved is of the same day, it is to calculate it as you will use subtraction. The difference comes in when the times involved are of different days.

Example:

Suppose you were asked to calculate the time a train took in different stops.

Arrival TimeDeparture Time
8:15 AM12:30 PM
1:00 PM2:15 PM
3:00 PM3:50 PM
5:20 PM6:30 PM

We begin by transferring our data to an excel spreadsheet.

Calculate Time in Excel.

We then subtract column B from column C.

Calculate Time in Excel.

But when we subtract like this it gives us the answer in AM and PM.

To rectify this, we select the the time column cells and right click, we go to format cells then click on custom and change the format to “h,mm” and click OK.

Calculate Time in Excel.

We end up getting our answer in hours and minutes.

 Calculate Time in Excel.

Therefore, we can say in the first stop, the train took 4 hours and 15 minutes.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How to Calculate Loan Payment.
A loan is when money is given to another party …

How to Calculate Loan Payment.

How to Calculate Proportion.
A proportion is simply a statement that two ratios are …

How to Calculate Proportion.

Leave a Reply Cancel Reply

Popular Posts

  • 5 Best AI Apps for Solving Complex …
    March 22, 2023 0

Categories

learntocalculate.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

How To Calculate

Learn how to calculate anything

Pages

  • About Us
  • Contact Us
  • Privacy Policy
Copyright © 2023 How To Calculate

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh