How to get sum of particular column values?

Help Activities
, ,
1

I have some values in Excel in hh:mm format. I need to find some of the all hh:mm type variables(First column). Sample Excel attched
Book1.xlsx (8.0 KB)

2

Hello @BNK
Main.xaml (10.9 KB)
Here the code
Hope this works

3

Hi @BNK ,

Step1: Read the file as InputDT
Step2: Use Assign Activity

outTotal = InputDT.AsEnumerable.Sum(function(x) Cdbl(TimeSpan.Parse(CurrentRow(“Total”).ToString).Hours))

4

I need Total hours

5

Hi @BNK ,

Can you try this you will total hours from this expression

Step1: Read the file as InputDT
Step2: Use Assign Activity

outTotal = InputDT.AsEnumerable.Sum(function(x) Cdbl(TimeSpan.Parse(CurrentRow(“Total”).ToString).Hours))

6

@BNK
image
Just change the last write range
TotalTime.TotalHours.ToString

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.