Calculating age in hours can be helpful for various purposes, such as calculating the duration of a project or measuring the elapsed time since an event occurred. Fortunately, Google Sheets provides several functions that make it easy to calculate age in hours.
Contents
Calculate the Hours
Here’s how you can calculate age in hours using Google Sheets:
 Enter the date and time you want to calculate the age from in one cell and the current date and time in another cell. For example, if you calculate the age of a project from the start date and time, enter the start date and time in cell A2 and the current date and time in cell B2.
 In another cell, enter the following formula:
=(B2A2)*24. This formula
subtracts the start date and time from the current date and time, giving the elapsed time in days. It then multiplies the result by 24 to convert the elapsed time to hours.  The result will show the age of the project in hours.
For example, if you apply this formula to a project that started on May 1st, 2023, at 10:00 AM and the current date and time is May 11th, 2023, at 2:30 PM, you’ll get the result “244.50 hours”.
⚠️ For a dynamic result that shows the current age, use the NOW function for the value in B2
.
Round the Result
If you want the result to show only whole hours elapsed, add the INT function to remove the decimal. The formula looks like this: =INT((B2A2)*24)
.
⚠️ Using INT removes the decimal value, but go to the menu bar and click Decrease decimal places twice to hide the two zeroes after the whole number.
Live Examples in Google Sheets
Make a copy of this Google Sheet to use the example.
TIMEDIF For Hours, Minutes, Seconds – No Formulas
For a mixed output with units other than hours, consider using the TIMEDIF addon. This addon creates an accurate result with no code.
Related Tutorials

Understanding Data Types in Google Sheets
Learn about the different types of data you can use in a spreadsheet.

DATEDIF Function – Google Sheets
The DATEDIF function calculates the difference between two days. You can return the difference in days, months, years, or combinations. Whereas the DAYS function will only return days, this function has multiple output options. The input for this function needs to be either surrounded by quotes or a cell reference. If your days, months, and…

DAYS Function – Google Sheets
The DAYS function calculates the number of days between two dates.

Date Functions – Using Dates and Times in Google Sheets
Learn the nuances of working with dates and times in Google Sheets.

How dates and times work in Google Sheets
Contents1 How Dates Work1.1 Using Dates in Formulas1.2 Subtracting Two Dates: Example 11.3 Subtracting Two Dates: Example 21.4 The Beginning of Time2 How Times Work3 How Dates and Times Work Together3.1 Live Examples in Sheets4 Related Tutorials How Dates Work Though it may not be obvious initially, spreadsheets store dates as numbers instead of text.…