Hi,
I am a novice with little formula knowledge and I am building my first app to track the performance sales order processing. I am trying to calculate the number of working days it has taken to process and deliver an order. I have used the following formula:
IF(ISBLANK([Delivered Date]) OR ISBLANK([Created Date]), "", WORKDAY([Delivered Date], 0) - WORKDAY([Created Date], 2))
The formula works, but the result is not displaying how I would like it to. As an example, the app displays:
"5.00:00:00" whereas I would like it to display as "5".
Is this a formatting issue with the column type (Number), or am I looking at this incorrectly?
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |