Convert decimal time to KNIME time format

[michael_tanner]

Hi
I’m new to KNIME and working with my first workflow. I have a CSV with daytime information in decimal format like 7.25 (means 7h 15min). I tried different nodes also in combination but was not able to bring it to KNIME time format hh:mm.

Any suggestions?

Thanks,
Regards,
Mike

[andrejz]

Hi,

Here is an idea on which you can work (Time Decimal conversion.knwf (30.0 KB) )

[michael_tanner]

Hello andrejz

Wow, thanks a lot, that is what I’m looking for. Great example how to do things like that. Not that easy as I expected…

Thank you!

Regards,
Mike

[andrejz]

Hi,

Here is another example with less nodes Time Decimal conversion.knwf (23.0 KB).

[ipazin]

Hi there,

nice one @andrejz!

Additionally one can use Column Expressions with time() function and a bit of string manipulation.
Time Decimal conversion_ipazin.knwf (43.4 KB)

Welcome to KNIME Community @michael_tanner!

Br,
Ivan

[michael_tanner]

Hi Ivan

Nice way to do!
Thanks for the warm welcome in the Community!

Regards,
Mike