Excel Manual (hh:mm:ss) Time Gets Changed To Generic Format During Execution

News Knowledge Base
1

When trying to get data from Excel sheet using Read range activity, the particular column format is (hh:mm:ss), after extracting data, why is the format is changing into Generic format?

Issue Description:
When trying to get data from Excel sheet using Read range activity, the particular column format is (hh:mm:ss), after extracting data, why is the format is changing into Generic format. For e.g., the Excel format is (00:20:15), but after extracting data from Excel in data table, value is in this format: (0.0140625).


Resolution: Use the below code logic and make the necessary changes accordingly,

  1. Change the variable type to "generic value" and pass the same in format activity accordingly
  2. Then set the Format type as Date and time
  3. Pattern as (hh:mm:ss)