Add time values in Excel

mrowe

Board Regular
Joined
Feb 17, 2002
Messages
232
Hi,

Can some one help me.

I need to add up a range of time values to determine the total time taken for a series of eventss.

e.g.

1:43:15 would represent 1 hour, 43 minutes and fifteen seconds
0:10:00 would represent 10 minutes

Total time 1:53.15

Thanks
Matt
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
If 1:43:15 is in cell A1, and 0:10:00 is in cell A2, then the total in cell A3 could be calculated as =A1+A2

If you think the total hours will be more than 24 then format the cell as [hh]:mm:ss
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows
Matt

Can't you just use a simple addition formula like =A1+A2?

Worked for me.:)
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547

ADVERTISEMENT

My pleasure! :biggrin:
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Glenn

I like the usage of the [] around the hh - I didn't know it would have that effect.

Richard
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Hi Richard,

yes, very useful to know that. Not that I sum times very often, but when I do I always need that trick.
 

Forum statistics

Threads
1,136,305
Messages
5,674,984
Members
419,540
Latest member
Nereus A

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top