I had a time in DT. How to add all time values

Help StudioX
,
1

I had a time in DT. How to add all time values.
Example
6:37 PM
12.03 PM
Total is 18:40 PM

2

@Puneet_Singh1

Can you please give some more clarity…as 6:37 PM is already 18:37

And in 24 hour format you wont have AM and PM

cheers

3

Hi @Puneet_Singh1

Please refer the below workflow to add all time values.
Input:
6:37 PM
12:03 PM
Output: 6:40
Main.xaml (15.9 KB)

Hope it helpss!!
Regards,

4

its not in 24 hour format
but we can do it in 24 hour format

5

My time is in datatable and it could be 2-5 rows.
How we can do that. in you example you are doing in array list

6

Hi @Puneet_Singh1
Can you share the screenshot of the datatable. I will get the solution for you.
Regards

7

right now dont know snap but it look like

image

8

can you try this TimeSpan.Parse(“12:03”).add(TimeSpan.Parse(“6:43”)).ToString
you can replace the values with your row values using for each

9

Hi @Puneet_Singh1

I have shared the workflow below for your reference. Please check and see whether it’s working fine at your side.
Main.xaml (17.3 KB)

Hope it helps!! Happy Automation
Regards,

10

can you please provide a zip file the
above xaml was not opening in my pc

11

Hi

I have uploaded the zip file for reference.
Test.zip (2.0 MB)

Thanks and Regards,

12

Just place the ,message box inside for each loop so that for each row iteration it will displays the added time…
Thanks and Regrads

13

Hi @Shiva_Nikhil
Since it was asked for the total time after adding all the three time message box / Write Line should be placed outside the For each loop.

Regards

14

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