How to Add Time in Google Sheets & Excel (Step-by-Step)

Quick answer: To add time in Google Sheets, enter times in HH:MM format and use =A1+B1 or =SUM(range), then format the result as Duration (Format > Number > Duration) so totals past 24 hours display correctly. To add a set number of hours, use =A1+TIME(h,m,s). Full steps below.

‍

1. Manual methods: classic ways to add time

When your dataset is small, manual methods in Google Sheets and Excel are perfectly fine. Here are practical options you or your team are probably already using.

‍

1.1 Direct time addition (cell + cell)

Google Sheets

1. Enter a start time in A1, e.g. 09:15.
2. Enter the duration you want to add in B1, e.g. 03:20:00.
3. In C1, type: =A1+B1.
4. Go to Format → Number → Time to display as time.

Docs: https://support.google.com/docs/answer/3093281

Excel

1. Enter 09:15 in A1 and 03:20 in B1.
2. In C1, use =A1+B1.
3. On the ribbon, choose Home → Number → Time.

Docs: https://support.microsoft.com/en-us/office/add-or-subtract-time-6a18e8de-0f37-49f5-ae46-5c66fe63c3e4

This is ideal for a few rows or quick checks.

‍

1.2 Using the TIME function

When you want to add a specific number of hours, minutes, or seconds:

Google Sheets

• Example: add 2 hours 30 minutes to A1.
  • Formula: =A1+TIME(2,30,0)

Excel

• Same example:
  • Formula: =A1+TIME(2,30,0)

This approach is great when durations are not already stored as time values.

‍

1.3 Adding time as fractions of a day

Both Google Sheets and Excel store time as a fraction of a day. That lets you add time with arithmetic:

• 1 hour = 1/24
• 1 minute = 1/(24*60)
• 1 second = 1/(24*60*60)

Google Sheets example:

• Add 5 hours to A1: =A1+5/24

Excel example:

• Add 90 minutes to A1: =A1+90/1440

This scales well if you’re dynamically calculating hours from other numbers (like billable hours × rate).

‍

1.4 Summing time across many rows

Google Sheets

1. Put daily work durations in A2:A10.
2. In A11: =SUM(A2:A10).
3. For totals over 24 hours, use a custom format: Format → Number → More Formats → Custom number format and enter [h]:mm:ss.

Docs: https://support.google.com/docs/answer/56470

Excel

1. List durations in A2:A10.
2. In A11: =SUM(A2:A10).
3. Set custom format [h]:mm:ss via Home → Number → More Number Formats.

Now weekly totals like 125 hours show correctly instead of wrapping after 24.

‍

1.5 Calculating differences between times

Google Sheets

• Duration in hours and minutes between start (A2) and end (B2): =B2-A2, then format as Duration.

Excel

• Same idea: =B2-A2, formatted as a time or custom [h]:mm.

This is the backbone for call logs, deliveries, and timesheets.

‍

2. No-code methods with automation tools

When your business grows, the pain is not the formula itself; it’s feeding and maintaining spreadsheets. This is where no-code tools help.

‍

2.1 Zapier or Make to enrich Sheets/Excel

Imagine a sales team where every closed call in your CRM must land in Google Sheets with call duration added to a weekly total.

Workflow outline:

1. Trigger: “New call logged” in your CRM (e.g., HubSpot, Pipedrive).
2. Action: Zapier/Make adds a new row in Google Sheets with start time and end time.
3. In Sheets, a prebuilt formula column calculates =B2-A2 and another column adds that duration to a running total.

You still rely on Google Sheets formulas, but no one is copy-pasting times anymore.

Docs (Zapier + Sheets): https://zapier.com/apps/google-sheets/integrations

Similarly, you can push data into an Excel workbook stored in OneDrive using Power Automate.

‍

2.2 Power Automate for Excel time workflows

For Microsoft-heavy teams:

1. Use Power Automate with a trigger like “New form response” or “New row in a Dataverse table”.
2. Action: “Add a row into a table” in an Excel file.
3. In Excel, your template sheet already contains time formulas (e.g., =SUM(Table1[Duration])).

Docs: https://support.microsoft.com/en-us/office/get-started-with-power-automate-5dfffaa3-184c-4e10-9e9f-3d8b0ee9a5b0

Pros:

• Great for structured, repeatable flows.
• Non‑technical team members can maintain.

Cons:

• Still limited to pre-wired scenarios.
• Struggles with messy exports or ad-hoc changes.

‍

2.3 App Scripts and Office Scripts for light coding

If you have a slightly more technical team member, scripts can auto-fill time formulas in bulk.

Google Apps Script

• A script can loop over imported rows, convert text timestamps to proper time values, and write =A2+TIME(1,0,0) formulas automatically.

Docs: https://developers.google.com/apps-script/guides/sheets

Office Scripts for Excel on the web do the same inside Microsoft 365.

Pros:

• Very flexible; you control the logic.

Cons:

• Requires maintenance and scripting skills.

‍

3. Scaling with AI agents (Simular-style automation)

At some point, even no-code flows feel brittle. Exports change, columns move, someone adds a new sheet, and everything breaks. This is where an AI computer agent shines: it behaves like a power user who understands your intent and operates Google Sheets and Excel directly.

3.1 Agent-driven time clean-up and formatting

Picture this: every Friday, your team drops CSVs from CRM, ad platforms, and time trackers into a folder. An AI agent then:

• Opens Google Sheets or Excel.
• Detects columns that look like start/end times.
• Converts text timestamps to time format.
• Inserts formulas like =B2-A2 and =SUM(C2:C1000).
• Applies [h]:mm:ss formatting for totals.

Pros:

• Survives layout changes because the agent sees the screen and understands context.
• No need to constantly rebuild Zaps or scripts.

Cons:

• Requires an initial “onboarding” of the agent to your exact workflow.

‍

3.2 Cross-app workflows for sales and marketing

A Simular-style agent can go beyond the spreadsheet:

1. Log into your CRM.
2. Export call logs or campaign performance.
3. Open Google Sheets or Excel.
4. Paste data, normalize date/time columns, and add durations.
5. Update dashboard tabs that your leadership sees every Monday.

This is powerful for agencies managing many clients: the same agent can repeat that multi‑step process across dozens of spreadsheets with production‑grade reliability.

‍

3.3 When to move from manual to AI agents

You should consider bringing in an AI agent when:

• You repeatedly teach new hires the same time formulas.
• Your reports combine multiple exports and apps.
• Errors in time totals directly impact invoices or ad budgets.

By first understanding the manual and no-code methods above, you define the “playbook” the agent will follow. Then, the AI computer agent simply executes that playbook across Google Sheets and Excel at a scale and speed no human team wants to match.