Converting number column to time hh:mm

Help Studio
, ,
1

Hi,

I have a process that grabs data from an excel, sorts & double keys on another platform. My issue is that when i initially grab the data in to a .csv document, the Time column shows as 44273.375 instead of 09:00. Is there a way that i can convert the datatable column in to hh:mm format before it prints it in the .csv?

Thanks

2

@PJ_17
give a try on a conversion similar to below
grafik

As it comes from CSV we also will handle string to Double conversion like:
grafik

3 Likes
3

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