Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hey all
can anyone tell me how can i multipla an interval of time by a number
Example
00:01:00 multiply by 7 equal 00:07:00
Thank you,
Hi
Could you please clarify your question a bit more. Can you explain what you are trying to achieve and why.
for example if the time was 00:02:00 or 00:59:00 what answer would you expect?
Hi
An interval is just a number, in decimal days (eg 1 = 1 day/24 hours, 1.25 = 28 hours, 0.25 = 6 hours/360 minutes). So an interval can be multiplied like this
=Interval(Interval#('00:01:00', 'hh:mm:ss') * 7, 'hh:mm:ss')
=Interval(Elapsed * 7, 'hh:mm:ss') // using field [Elapsed] containing an interval
HTH
Jonathan
Thank you Jonathan it Works
Hi Mario
I wasn't sure that this is what you were asking for. Great that it worked. Could yo please mark Jonathans answer as correct?
Regards