Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You should be able to adapt this to your needs :
interval ( interval# ( '150:00:00' , 'h:mm:ss' ) * 13 , 'h:mm:ss' )
You should be able to adapt this to your needs :
interval ( interval# ( '150:00:00' , 'h:mm:ss' ) * 13 , 'h:mm:ss' )
Thanks Bill for your quick help 🙂