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

example.yxmd