Time Format

[vikasgupta]

Hi All,

I have one straight Table with time format and one field is number of allocated member and i wants to calculate as per example .

Please find the screenshot for same

For example I wants to calculate 150:00:00 * 13 = 1950:00:00

Time for mat excel is hh:mm:ss

Thanks

[Anonymous · Accepted solution]

You should be able to adapt this to your needs :

          interval ( interval# ( '150:00:00' , 'h:mm:ss' ) * 13  , 'h:mm:ss' )

[vikasgupta]

Thanks Bill for your quick help 🙂