How to sum time column in excel using c#

Question

0.00/5 (No votes)

See more:

Hi all,

Can i know how to sum time column values in excel using c#. I am using OLEDB for reading data from excel through c# code.

Below is my time column value.
TimeColumn
==========
0:02:37
0:03:58
0:02:31
=========
sum: 0:09:06

Regards
Hyma

Posted 16-Nov-15 15:13pm

HymaKG

Add a Solution

Comments

BillWoodruff 17-Nov-15 9:29am

What exactly are you doing in C# here: are you reading in data (time values) already in the Excel WorkSheet, or are you computing those values in C# and writing them into the Excel WorkSheet ?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

George Jonsson · Answer 1 · 2015-11-16T16:54:00

In C# it is easier to do addition if you convert your values into the TimeSpan[^] type.
(I assume here that the times here represents a duration and not the time of the day)

C#

TimeSpan ts1 = TimeSpan.Parse("0:02:37");
TimeSpan ts2 = TimeSpan.Parse("0:03:58");
TimeSpan ts3 = TimeSpan.Parse("0:02:31");

TimeSpan sum = new TimeSpan();
sum = sum.Add(ts1);
sum = sum.Add(ts2);
sum = sum.Add(ts3);

Of course you can skip the temporary variable ts1-ts3.

C#

sum = sum.Add(TimeSpan.Parse("0:02:37"));

but it might be better to start with separate variables to make it easier to debug.

Then of course you should probably do this in a loop, but that is up to you.

BillWoodruff · Answer 2 · 2015-11-16T17:44:00

Yes, you can use standard addition formulas to add cells with 'time values.

However, if you ever have a case where the total time is greater than 24 hours, you need to do something like this: [^].

In any case it's good practice to select the cells you want to show time totals in and choose a custom format like: [h]:mm to show hours and minutes, or [h]:mm:ss to show hours, minutes, seconds.

Patrice T · Answer 3 · 2015-11-16T15:29:00

Solution 1

In Excel, the simple sum of the 3 cells gives you the answer.
Excel automatically recognize a time value.
So, if you have
A1=0:02:37
A2=0:03:58
A3=0:02:31
a simple sum gives you the result
A4=A1+A2+A3

Posted 16-Nov-15 15:29pm

Patrice T

Comments

George Jonsson 16-Nov-15 22:42pm

The question was how to do it in C#.
(I think)

Patrice T 16-Nov-15 22:53pm

It is possible, but in this case, there no need to speak about Excel at all.
More details would be welcome.

George Jonsson 16-Nov-15 22:55pm

True. But it is better to confuse the enemy. :-)

Patrice T 16-Nov-15 23:02pm

:-)

How to sum time column in excel using c#

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0