Total and subtotal of datetime column

Question

1.00/5 (1 vote)

See more:

Hi guys,

I need to find the total and subtotal of datetime column in gridview.

iam using gridview helper( http://www.agrinei.com/gridviewhelper/gridviewhelper_en.htm[^] )

to find the solution.It is working for integer values

for datetime column it is displaying as string eg. 08:30:0005:30:00,I need the result

to be

1st row -> 08:30:00
2nd row -> 05:30:00

result  -> 14:00:00

can anyone please help me to find the solution.

Thanks in advance.

Posted 30-Sep-14 6:17am

saisrid

Updated 30-Sep-14 6:33am

Wendelius

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 30-Sep-14 12:36pm

Solution for what? What would be the meaning of summing up points in time? I would understand if you sum up durations (time spans), it would make perfect sense.
—SA

1 solution

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2014-09-30T06:41:00

Solution 1

It is apparent that you obtained string concatenation, and not numeric calculation. Probably you just used '+' operator on strings.

No, please see my comment to the question. Summing up objects of the type System.DateTime makes no sense at all; they represents points on the time axis.

Consider using System.TimeSpan instead. But before calculating the sum, you need to parse the string to this type. Please see all the methods named Parse, ParseExact, TryParse and TryParseExact:
http://msdn.microsoft.com/en-us/library/system.timespan_methods%28v=vs.110%29.aspx[^].

—SA

Posted 30-Sep-14 6:41am

Sergey Alexandrovich Kryukov

v2

Comments

saisrid 30-Sep-14 13:57pm

Sorry as iam new to dotnet, my way of queries may not be understandable will rectify in future.

As per your advice, I have tried using TimeSpan.Parse()

// changes done in code.

case "System.TimeSpan": return TimeSpan.Parse(a) + TimeSpan.Parse(b);

I have got compilation error as:

CS1502: The best overloaded method match for 'System.TimeSpan.Parse(string)' has some invalid arguments

Please advice.

Sergey Alexandrovich Kryukov 30-Sep-14 14:02pm

Your "a" and "b" must be strings representing TimeSpan. Read about formats of TimeSpan represented by string. Just read starting the page I referenced.
Prefer TryParse, TryParseExact, if you can possibly expect parsing exceptions, to avoid them.
—SA