Hi

I've been trying to find the most efficient way to convert from one time format to another. Example, I want to convert 569 min 227 sec to hh:mm:ss. Is there a quick easy way to do this?

The new date time action in Djuggler 3.2.1 should do the trick.

See the attached example.
Tijn

Thanks for the reply Tjin.Unfortunately I made a mistake in the post - the actual times are supposed to be seconds/milliseconds - so the example should have been:
569 sec 227 milliseconds. It seems the datetime actions may not work with this...is this so?

The add to date time does not support milliseconds.
The format action however does: hh:mm:ss:zzz

I think you have to use the Math action in the variables section and make your own calculation for the milliseconds.

Thanks for the reply Tjin.

If I separate out the second from the millisecond, in the example= 569 sec and then divide by 86400 I then get a number (0.0065856), which if formatted in Excel as hh:mm:ss will give me the what I known is the correct number: 0:09:29.

However I have not been able to do this in djuggler with the date format action - I always get 00:00:00. Unfortunately, as my maths are very basic, I would very much appreciate some help. Thanks.

@Jim:

Unfortunately you are right. Currently, milliseconds can not be added or set in a DateTime var. That means you can't work with or display milliseconds in a datetime var. You could probably circumvent the whole issue by using Number variables for each unit (seconds, msecs, mins), but that will take quite a few script lines.

We will expand the DateTime actions in the next release of Djuggler. The DateTime actions will then support milliseconds as well.

Support Team

Thanks for the quick response Support Team. I look forward to the addition. Will you also include conversion from decimal time to standard time?