Formatting Issue with Workday Duration Between 2 Dates

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?

0 1 107
1 REPLY 1

 
IF(
   OR(
      ISBLANK([Delivered Date]),
      ISBLANK([Created Date])
   ),
   "",
   WORKDAY([Delivered Date], 0)-WORKDAY([Created Date], 2)
)
Top Labels in this Space