App Tutorial

Convert Time to Minutes in Google Sheets: Easy Steps

Jason Gong
App automation expert
Apps used
Google Sheets
April 15, 2024

Learn to convert time to minutes in Google Sheets using formulas or by changing cell format. This guide covers multiple methods, including using HOUR and MINUTE functions, the SPLIT function, and direct conversion formulas, as well as how to display time in minutes by altering cell format.

Master these techniques to effectively manage and analyze time data for your projects.

Enhance your Google Sheets productivity by automating repetitive tasks with Bardeen.

Google Sheets Convert Time to Minutes

Converting time to minutes in Google Sheets is a common task that can be accomplished through various methods, including formulas and formatting options. This guide will walk you through different approaches to convert time duration into minutes, ensuring you can handle time data effectively for your calculations or data analysis.

Automate repetitive Google Sheets tasks and save time with Bardeen. Discover powerful automations like copying Asana tasks to Google Sheets!

Method 1: Using Formulas

There are several formulas you can use to convert time to minutes in Google Sheets, depending on the format of your time data and your specific needs.

  • Formula using HOUR and MINUTE functions:'=HOUR(A1)*60+MINUTE(A1)'. This formula assumes the time duration is in cell A1 and converts it into minutes by multiplying the hours by 60 and adding the minutes.
  • Formula using SPLIT function:'=index(split(A1,":"),1)*60+index(split(A1,":"),2)'. This method splits the time duration in cell A1 by the colon, then calculates the total minutes.
  • Direct conversion formula:'=VALUE(B2*24*60)'. This formula converts the time duration in cell B2 directly into minutes, leveraging the fact that time in Google Sheets is stored as a fraction of a day.

Each of these formulas can be typed directly into a cell where you want the result to appear. After entering the formula, press Enter to see the conversion.

Method 2: Changing Cell Format

Another way to convert time to minutes without using formulas is by changing the cell's format:

  1. Select the cell or range of cells with your time duration.
  2. Go to Format > Number > More Formats > Custom number format.
  3. Enter 'mm' in the custom format field to display the total minutes, or '[mm]' for elapsed minutes if your durations exceed 24 hours.
  4. Click Apply.

This method changes how the time is displayed in the cell, showing only the minutes part of the time duration.

Google Sheets Convert Time to Decimal

Converting time to decimal is closely related to converting time to minutes, as it involves representing time durations in a decimal format rather than hours and minutes. This can be useful for calculations or when working with systems that require time in decimal form.

To convert time to decimal in Google Sheets, use the formula: '=HOUR(time)+(MINUTE(time)/60) + (SECOND(time)/3600)'. Replace 'time' with the cell reference containing your time duration. This formula breaks down the time into hours, minutes, and seconds, then converts it to a decimal format.

For example, to convert the time in cell A2 to decimal, you would use: '=HOUR(A2)+(MINUTE(A2)/60) + (SECOND(A2)/3600)'. After entering the formula, press Enter, and the time will be displayed in decimal hours.

To apply this formula to multiple cells, you can drag the fill handle down or double-click it to auto-fill based on adjacent data. If needed, adjust the number of decimal places displayed by using the toolbar options.

Explore our Google Sheets automations and enhance your productivity. Automate your sheets with addons as discussed in our blog post.

These methods provide flexibility in handling time data in Google Sheets, whether you need to convert time to minutes for calculations or to decimal format for integration with other systems or reports.

Automate Google Sheets Tasks with Bardeen

Converting time to minutes in Google Sheets can be done manually as described above, but imagine the possibilities if you could automate not just this, but many other repetitive Google Sheets tasks. Automation through Bardeen not only saves significant time but also minimizes errors, making your data management process more efficient.

Here are some powerful Google Sheets automations you can achieve with Bardeen:

  1. Get a daily summary of your emails and save to Google Sheets: This automation compiles a summary of your daily emails and saves it directly to a Google Sheet, perfect for tracking correspondence or managing customer support tickets efficiently.
  2. Copy a newly created Asana task to Google Sheets: Automate the process of documenting new tasks by copying details from Asana directly into your Google Sheets. Ideal for project managers and teams looking to streamline task tracking.
  3. Send a Slack message counting the rows in a Google Sheet: Keep your team informed by automatically sending Slack messages that count and report the number of rows in a specific Google Sheet. Great for sales teams tracking leads or finance teams monitoring expenses.

Discover more ways to enhance your productivity by downloading the Bardeen app at

Other answers for Google Sheets

How to Disable Download Option in Google Sheets

Learn how to disable downloads in Google Sheets by adjusting share permissions and protecting sheets, enhancing data security.

Read more
How to Download Specific Parts of Google Sheets

Learn how to download specific parts of Google Sheets using the sheet's GID for efficient data sharing and analysis. Streamline your workflow today.

Read more
How to Download Images and Charts from Google Sheets

Learn how to download images and charts from Google Sheets directly or from a URL list to Google Drive, including step-by-step instructions.

Read more
How to Convert Google Sheets to Excel

Learn to download Excel from Google Sheets in a few steps, ensuring file compatibility and offline access. Perfect for Excel users.

Read more
Effective Methods to Convert Numeric Dates to Written Months

Learn how to convert numeric dates to written months in Google Sheets using TEXT function, custom formatting, and more for enhanced data presentation.

Read more
Convert Time to Text in Google Sheets

Learn how to convert time to text in Google Sheets using the TEXT function and built-in formatting options for clear data presentation.

Read more
how does bardeen work?

Your proactive teammate — doing the busywork to save you time

Integrate your apps and websites

Use data and events in one app to automate another. Bardeen supports an increasing library of powerful integrations.

Perform tasks & actions

Bardeen completes tasks in apps and websites you use for work, so you don't have to - filling forms, sending messages, or even crafting detailed reports.

Combine it all to create workflows

Workflows are a series of actions triggered by you or a change in a connected app. They automate repetitive tasks you normally perform manually - saving you time.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use
Reading time
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.