Excel Read column value
Question
Application Type
Reactive
Service Studio Version
11.10.12 (Build 39150)

Hi

In Excel I have Column with data type as

I am importing this column by import Excel to Record list.

In the structure attribute I have data type Text to receive the the value which is 11.02754711 for the 264:39 value in Excel.

So, In outsystems I am geting value 11.02754711 but how to convert it to 264:39 in Outsystems.

Thanks in advance.....

mvp_badge
MVP
Solution

Hi Rohan,


You are receiving the value in days and you need it in hours and minutes.

You can create a function that converts days into hours and minutes and use it on the excel value before using this value on your logic flow.

The algorithm is simple math as you can see here:


Hope it helps.


Kind Regards,
João

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.