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 🙂
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