Hello,

I have a time tracking column which tracks the time spent on a task by hours, minutes and seconds.

I would like to calculate the number of days spent on the task.

I have tried multiple ways to make the formula in a separate formula column, but the result is not satisfactory.

The current formula iteration is

DIVIDE({PENDING WITH SALES#Hours}, 24)

But the value I receive in terms of days is nowhere near the expected results.

What am I doing wrong here?

Please help experts