Going from numeric format back to time format

[Clandmann]

Hello,

For this workflow I am adding up amount of hours worked. in order to do this I convert to minutes and sum them up. When this data is recombined its formatted so the 6.5 represents 6 and a half hours instead of 6:50 min. I am trying to convert the [Other Hours] column back to a time standard.

I have been trying a few differed ways of going about this but have not had any luck.

Any help or advise is greatly appreciated. 

THANK YOU 🙂

[AngelosPachis]

Hi @Clandmann ,

I have used a formula tool to parse the minutes from % of an hour and convert them to actual minutes.

Then I have put the string back together, to form the complete time string.

Hope that helps, let me know if that works for you or you have any questions.

Cheers,

Angelos