Having time in HH:SS in excel and my requirement is to add the total time

[Puneet_Singh1 (Puneet Singh)]

Example
Column A has 02:20
Column B has 00:30
Column C has 00:10

Total should display as 03:00

Please help how we add. Adding normally is not working showing incorrect result

Or same data i have in datatable how we add that in datatable. I mean if we didnt write in excel then are we able to calculate the time in DT table.

[ppr (Peter Preuss)]

we can do:

So Just retrieve the time strings and sum it up as show cased above

[Puneet_Singh1 (Puneet Singh)]

My time is in DT how we pass that.

[ppr (Peter Preuss)]

as a plain column value retrieval

Let’s assume you are looping over the rows with a For each row in Datatable | CurrentRow in YourDataTableVar

arrTimes = {"Column1","Column2","Column3"}.Select(Function (x) CurrentRow(x).toString.Trim).toArray
mySum = TimeSpan.FromTicks(arrTimes.Sum(Function (x) CDate(x).TimeOfDay.Ticks))

[Puneet_Singh1 (Puneet Singh)]

Sorry sir… Getting error i am doing something wrong.

Please guide

[ppr (Peter Preuss)]

@ppr

arrTimes = {"Column1","Column2","Column3"}.Select(Function (x) CurrentRow(x).toString.Trim).toArray

above was mentioned. A string Array with the column name from which you want to retrieve the time strings

[Puneet_Singh1 (Puneet Singh)]

Thanks sir…Still not get it. Let me see it. My column are not fixed.
I already stored data in table and from there how i iterate that value and add those.
Will check and look how i do it.

[ppr (Peter Preuss)]

just redefine the requirement with all details and we check afterwards

[Puneet_Singh1 (Puneet Singh)]

@ppr

mySum = TimeSpan.FromTicks(arrTimes.Sum(Function (x) CDate(x).TimeOfDay.Ticks))

Getting below error