How to Calculate the working days and return the value in terms of day and hours like "4.75"

Topic Labels: Dates & Timezones Formulas
423 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have made a formula to calculate the date difference between start date and end date and returns a value in terms of day and hours as a fraction like "4.75" here is the formula

  {End Date} >= {Start Date},
  ROUND(DATETIME_DIFF({End Date}, {Start Date}, 'hours') / 24, 2),
But right know i want to change the above formula only for working days tho, i know there is a formula to calculate the working days difference  
WORKDAY_DIFF({Start Date}, {End Date}) hence it returns in terms of days only like "4" but i want to return the hour also like "4.71"


1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

The hard part of this is you would need to determine the hours in a day that are working hours too which the formulas aren't really meant to account for.