How Can one Multiply Time?

[#1]

Hi there,

I'm faced with a Dilemma that I need to multiply the number of hours and minutes and it's not happening.

For example, TIME('15:30' *2, 'hh:mm'), this calc above gives me 07:00 but I want it to give me 31:00 hours.

Another question: How can one get the duration it took one to solve a request if you have the Request Date(YYYY-MM-DD hh:mm:ss TT)

and the Requst Solvde Date(YYYY-MM-DD hh:mm:ss TT)? Simple getting an interval of the two dates whould give the right answer but now I need to exact duration (The one that excludes weekends, holidays and also excludes after hours(5pm to 8am)).

I hope this is understood.

[CELAMBARASAN · Accepted solution]

Try with interval function

Interval('15:30' *2, 'hh:mm')

[#3]

Thank you Celambarasan Adhimulam

[swuehl]

You can find an approach to solve your second issue e.g. here.