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

Hi @JCorrell
Basically, using the time tracking column, I am trying to understand how many days has been spent in finalizing a task.

The time tracking column tracks tasks by hour, minutes and seconds.
Ideally, if I where to divide the numbers of hours by 24, I should get the number of days.

However, when using the formula DIVIDE({PENDING WITH SALES#Hours}, 24), I am not getting proper results. The key here is the #Hours

Hope this would clarify things
Thanks for taking interest in this case

@Jcorrell
Thank you so much for your reply.
As an example below, the first column reflects the timer, the second column reflects the formula, which should be ideally in days, as you can see in the 2nd column, the formula doesnâ€™t seem to work.

Hoe this helps
Once again, thank you so much for taking interest in this case

There doesnâ€™t appear to be any correlation between the time tracking column and the formula values. At this point, I would recommend contacting monday support regarding the issue.

Hi Team,
I am sorry for spamming everyone on this, but I need some help in writing a formula to calculate the number of days passed, which is linked to a timer column.

I tried multiple iterations of different formulas, but could not get the desired results.
Could you please advise on whom should I be speaking to for this please
Thanks a ton in advance, and once again, sorry for spamming everyone like this

Hi @itaishabtai
THank you so much for your reply.
This is monster formula!!!

I was wondering, if I wanted to only calculate the number of day, should the formula look something like this. Unfortunately, I am getting an error message

IF({PENDING WITH SALES#Hours}>=24,(INT(DIVIDE({PENDING WITH SALES#Hours},24),0)

Well in that case, we can use this formula:
ROUNDDOWN({Time Tracking#Hours}/24,0)

It will show you only the day number, but only if itâ€™s higher than the 24 hours (this is why i used round down). So for 23h it will show 0 while for 24 and 25 it will show 1:

You can then use the column summary to insert a unit, letâ€™s say: â€śdaysâ€ť

Hi @itaishabtai
Thank you so much for your reply.
The formula works like a charm.

However, there is one peculiarity.
On timers which are running, the formula doesnâ€™t run.
However, the timers which are paused, there is no problem with the formula.

For example, in the screenshot below the formula doesnâ€™t work on the timers which are still running.
Is there a way around for this please?
Thank you so much for responding

hi @Tabish youâ€™re correct! At the moment, the formula column will only read times that were stopped. While the clock is still running the time wonâ€™t be implemented/counted.

Sorry I canâ€™t offer a workaround for this one :X

It appears that when used in a formula, the value returned for a time tracking column is the value it was the last time it was stopped.

I looked at putting together a set of automations that would stop then restart time tracking once a day. I think itâ€™s possible, but not very simple. The primary issue being NOT restarting if it was not running.

However, this would be very easy using an Integromat scenario.