interval

[mario-sarkis]

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,

[Anonymous]

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?

[jonathandienst]

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

[mario-sarkis]

Thank you Jonathan it Works

[Anonymous]

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