Help

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

Topic Labels: Formulas
259 0
cancel
Showing results for 
Search instead for 
Did you mean: 
lucyk
4 - Data Explorer
4 - Data Explorer

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