Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Working Days of Monday to Friday and working hours of 9am to 5:15 pm in duration formula

posted Jan 16, 2024 10:29:50 AM

Topic Labels: Formulas

0 253 0

Hi All,

how would I amend the formula below to include Working Days of Monday to Friday and working hours of 9am to 5:15 pm in the out put?

INT(DATETIME_DIFF(NOW(), {Credit decision date}, 'hours')/24)&" Days "&MOD(DATETIME_DIFF(NOW(), {Credit decision date}, 'hours'), 24)&" Hours "&MOD(DATETIME_DIFF(NOW(), {Credit decision date}, 'minutes'), 60)&" Minutes"

0 Replies 0