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 Debt to Income Ratio.
Debt to income ratio mostly abbreviated as DTI is the …

How to Calculate Debt to Income Ratio.

How to Write a Number in Scientific Notation.
Scientific notation is defined as a standardized way to represent …

How to Write a Number in Scientific Notation.

Popular Posts

    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 © 2025 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