AnsweredAssumed Answered

How to convert number to time.

Question asked by muhammad.ikram@contedia.com on Jun 27, 2018
Latest reply on Jun 27, 2018 by user19752


Hello Community;

 

I have a number field where users enter time in number format for example 1.27 or 1.8 etc...

 

I want to convert this number into time. so for example 2.0 would show as 02:00:00.

 

And if possible I would also want to show time in following format.

 

2.0 = 2 Hours and 0 Minutes.

2.4 = 2 Hours and 21 Minutes.

 

So first I would like to convert number to time than to human readable format like above.

 

Many Thanks.

Outcomes