Summing Working Hours in a Day(DATATABLE)

[Gokul_Jayakumar (Gokul Jai)]

Hello @rockchord
Kindly refer to this thread it will heps you.

How to add the Time Duration in Excel?

Hello UiPathans! Check out this tutorial to know about the sum of Durations in excel of DT. Here are the steps Read the Excel sheet using the Read range activity. Create a variable with the System.TimeSpan Variable type. and assign 00:00 [image] Now Loop the process Using For Each DataTable. Here we have to identify the format of duration stored in excel by using write line activity. [image] [image] 4.1 In this 12/30/1899 08:20:00 we get in the format of “MM/dd/yyy…

Regards,
Gokul Jayakumar.