Transform a decimal to time

poppins

Hi everyone,

I need to transform a decimal value to a time.
Example: instead of 2.5, I need to display 2:30 (2 minutes 30 seconds).
How can I do that?

Thanks in advance

postsaurav

And why you want to do this...
+ How would you get a decimal value for 2 minutes 2 seconds..
Just want to understand what is the requirement.

einsTeIn.NET

Try something like this:
YourTime := 000000T [to make sure it is data type Time] + DecValueInMinutes * 1000 [ms] * 60 [seconds]

poppins

postsaurav wrote: »

And why you want to do this...
+ How would you get a decimal value for 2 minutes 2 seconds..
Just want to understand what is the requirement.

I have a field in tab 37 "Needed time" which represents the number of seconds needed for a certain operation...its type is decimal.
In table 36, I created a flowfield "Total needed time" to sum the values from the lines...
It is wanted to display the total needed time in minutes...
That is why I asked...

Peter+is1

Hello,

have a look here forum.mibuso.com/discussion/4722/add-decimal-to-time-variable .

(you would add the duration to a 0D 0T variable in your case)

I cannot think of an easier way...

Good luck, let me know if it helps...

rajavenkat74@gmail.com

HI
You could Try My way Like Here
Simple Just you have to Add another Duration type Datatype And Done