AnsweredAssumed Answered

How to convert number to time.

Question asked by 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.