I want to help from master

[Shubham_Bidwai]

i want to download/read google multiple sheet (sr no, name , number of hours )and calculate the hours and on new sheet with that respected name and send the info through gmail

[Gokul_Jayakumar (Gokul Jai)]

Hello @Shubham_Bidwai
Refer to this thread for reading the data from Gsheet

Read Cell and Read Range Activities to read Data from Google Sheets||RPA||UIPath||Gsuite Automation

Refer to this Tutorial, to sum up the hours.

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…

[Shubham_Bidwai]

@Gokul_Jayakumar cant solve the problem