Hi, Is there a way to stop this and have no decimal places?
Hi @Nick_Parsons1 Have you tried setting the numeric digits or if it is derived from a formula maybe include ROUND()
@Lynn Hi Lynn, Im not sure how, where would I add Round() to this formula?
If I can?
=IFS( ISNOTBLANK([Date Raised]),CONCATENATE(HOUR(NOW()-[Date Raised])/24," - (days)"), TRUE,CONCATENATE(""))
=IFS( ISNOTBLANK([Date Raised]),CONCATENATE(ROUND(HOUR(NOW()-[Date Raised])/24,0)," - (days)"), TRUE,CONCATENATE(""))
@Levent_KULACOGLU Hi Levent, I get an error, saying round invalid inputs?
=IFS( ISNOTBLANK([Date Raised]),CONCATENATE(ROUND(HOUR(NOW()-[Date Raised])/24)," - (days)"), TRUE,CONCATENATE(""))
@Levent_KULACOGLU You have done it again !!
Superb thank you.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |