Thanks for getting back to me!

Hm, if you’d like to subtract x amount of hours from each day, could something like this work for you?

Let me know

Thanks for getting back to me!

Hm, if you’d like to subtract x amount of hours from each day, could something like this work for you?

Let me know

What I ended up doing was making a date column for end date then using the creation log and date column to show workdays -1,

WORKDAYS({Stop Date},{Creation Log})-1

then used the summary of the column set to average to see the average turnaround time of products. Looks like this is the best solution at the time. Thank you.

1 Like

This is a great workaround Rachael Glad to see you were able to come up with something here!

Hey this is really problematic and time inefficient to not be able to easy and quickly see a summary of the time tracked and it makes the column a little pointless. In addition to not seeing the summary in the main groups, we can’t see the summary in subtasks either. This makes invoicing very time consuming for those of us needing to track actual hours and not estimates. This was feature that made me switch to Monday.com over other options so I could have all of my time tracking with the projects. Will there be any attempt to remedy this in the future?

Hey Caitlin,

I am really sorry to hear of your frustration here - I understand that especially for your use-case that this is a significant setback for you. Whilst I can guarantee a return of this feature in the near future, I can certainly share these comments with the team internally. We do ask that you submit this feedback via the dedicated form, as these comments go directly to the specific product team in-charge

Hi all,

I found a workaround to count hours and minutes between 2 datetime columns, I haven’t seen it yet in any forums so I’ll share it with you.

I tried using the timetracking column but it’s to restrictive to do anything with it, here is what I’ve done :

I have 2 datetime columns :

I will use those columns to determine opened hours, for my case I’m working from 9am to 6pm

Then you need 2 date time columns you want to count working hours from :

When you’re columns are set, create a formula column and paste the following code in :

```
IF(SUM(IF(AND(HOUR({Creation log}) > HOUR({Begin})-1,
HOUR({Creation log}) < HOUR({End}),
MINUTE({Creation log}) > 0),
60-MINUTE({Creation log}),
0),
IF(AND(HOUR({End date})-8 > 0,HOUR({End date})-8 < 12),
MINUTE({End date}),
0)) > 59,
IF(SUM(IF(AND(HOUR({Creation log}) > HOUR({Begin})-1,
HOUR({Creation log}) < HOUR({End}),
MINUTE({Creation log}) > 0),
60-MINUTE({Creation log}),
0),
IF(AND(HOUR({End date})-8 > 0,HOUR({End date})-8 < 12),
MINUTE({End date}),
0)) = 0,
CONCATENATE(SUM(WORKDAYS({End date},{Creation log})*MINUS(HOUR({End}),HOUR({Begin}))-(MINUS(HOUR({End}),HOUR({Begin}))*2),
IF(WORKDAYS({Creation log},{Creation log}) > 0,
IF(HOUR({Creation log}) < HOUR({Begin}),
MINUS(HOUR({End}),HOUR({Begin})),
IF(HOUR({Creation log}) < HOUR({End}),
IF(MINUTE({Creation log}) = 0,
MINUS(MINUS(HOUR({End}),
HOUR({Begin})),
MINUS(HOUR({Creation log}),
HOUR({Begin}))),
MINUS(MINUS(HOUR({End}),
HOUR({Begin})),
MINUS(HOUR({Creation log}),
HOUR({Begin})))-1),
0
)
),
0
),
IF(WORKDAYS({End date},{End date}) > 0,
IF(HOUR({End date}) < HOUR({Begin}),
0,
IF(HOUR({End date}) < HOUR({End}),
HOUR({End date})-HOUR({Begin}),
MINUS(HOUR({End}),HOUR({Begin}))
)
),
0
))+1,
"h0",
MOD(SUM(IF(AND(HOUR({Creation log}) > HOUR({Begin})-1,
HOUR({Creation log}) < HOUR({End}),
MINUTE({Creation log}) > 0),
60-MINUTE({Creation log}),
0),
IF(AND(HOUR({End date})-8 > 0,HOUR({End date})-8 < 12),
MINUTE({End date}),
0)),60),
"min"),
CONCATENATE(SUM(WORKDAYS({End date},{Creation log})*MINUS(HOUR({End}),HOUR({Begin}))-(MINUS(HOUR({End}),HOUR({Begin}))*2),
IF(WORKDAYS({Creation log},{Creation log}) > 0,
IF(HOUR({Creation log}) < HOUR({Begin}),
MINUS(HOUR({End}),HOUR({Begin})),
IF(HOUR({Creation log}) < HOUR({End}),
IF(MINUTE({Creation log}) = 0,
MINUS(MINUS(HOUR({End}),
HOUR({Begin})),
MINUS(HOUR({Creation log}),
HOUR({Begin}))),
MINUS(MINUS(HOUR({End}),
HOUR({Begin})),
MINUS(HOUR({Creation log}),
HOUR({Begin})))-1),
0
)
),
0
),
IF(WORKDAYS({End date},{End date}) > 0,
IF(HOUR({End date}) < HOUR({Begin}),
0,
IF(HOUR({End date}) < HOUR({End}),
HOUR({End date})-HOUR({Begin}),
MINUS(HOUR({End}),HOUR({Begin}))
)
),
0
))+1,
"h",
MOD(SUM(IF(AND(HOUR({Creation log}) > HOUR({Begin})-1,
HOUR({Creation log}) < HOUR({End}),
MINUTE({Creation log}) > 0),
60-MINUTE({Creation log}),
0),
IF(AND(HOUR({End date})-8 > 0,HOUR({End date})-8 < 12),
MINUTE({End date}),
0)),60)
,"min")
),
IF(SUM(IF(AND(HOUR({Creation log}) > HOUR({Begin})-1,
HOUR({Creation log}) < HOUR({End}),
MINUTE({Creation log}) > 0),
60-MINUTE({Creation log}),
0),
IF(AND(HOUR({End date})-8 > 0,HOUR({End date})-8 < 12),
MINUTE({End date}),
0)) = 0,
CONCATENATE(SUM(WORKDAYS({End date},{Creation log})*MINUS(HOUR({End}),HOUR({Begin}))-(MINUS(HOUR({End}),HOUR({Begin}))*2),
IF(WORKDAYS({Creation log},{Creation log}) > 0,
IF(HOUR({Creation log}) < HOUR({Begin}),
MINUS(HOUR({End}),HOUR({Begin})),
IF(HOUR({Creation log}) < HOUR({End}),
IF(MINUTE({Creation log}) = 0,
MINUS(MINUS(HOUR({End}),
HOUR({Begin})),
MINUS(HOUR({Creation log}),
HOUR({Begin}))),
MINUS(MINUS(HOUR({End}),
HOUR({Begin})),
MINUS(HOUR({Creation log}),
HOUR({Begin})))-1),
0
)
),
0
),
IF(WORKDAYS({End date},{End date}) > 0,
IF(HOUR({End date}) < HOUR({Begin}),
0,
IF(HOUR({End date}) < HOUR({End}),
HOUR({End date})-HOUR({Begin}),
MINUS(HOUR({End}),HOUR({Begin}))
)
),
0
)),
"h0",
SUM(IF(AND(HOUR({Creation log}) > HOUR({Begin})-1,
HOUR({Creation log}) < HOUR({End}),
MINUTE({Creation log}) > 0),
60-MINUTE({Creation log}),
0),
IF(AND(HOUR({End date})-8 > 0,HOUR({End date})-8 < 12),
MINUTE({End date}),
0)),
"min"),
CONCATENATE(SUM(WORKDAYS({End date},{Creation log})*MINUS(HOUR({End}),HOUR({Begin}))-(MINUS(HOUR({End}),HOUR({Begin}))*2),
IF(WORKDAYS({Creation log},{Creation log}) > 0,
IF(HOUR({Creation log}) < HOUR({Begin}),
MINUS(HOUR({End}),HOUR({Begin})),
IF(HOUR({Creation log}) < HOUR({End}),
IF(MINUTE({Creation log}) = 0,
MINUS(MINUS(HOUR({End}),
HOUR({Begin})),
MINUS(HOUR({Creation log}),
HOUR({Begin}))),
MINUS(MINUS(HOUR({End}),
HOUR({Begin})),
MINUS(HOUR({Creation log}),
HOUR({Begin})))-1),
0
)
),
0
),
IF(WORKDAYS({End date},{End date}) > 0,
IF(HOUR({End date}) < HOUR({Begin}),
0,
IF(HOUR({End date}) < HOUR({End}),
HOUR({End date})-HOUR({Begin}),
MINUS(HOUR({End}),HOUR({Begin}))
)
),
0
)),
"h",
SUM(IF(AND(HOUR({Creation log}) > HOUR({Begin})-1,
HOUR({Creation log}) < HOUR({End}),
MINUTE({Creation log}) > 0),
60-MINUTE({Creation log}),
0),
IF(AND(HOUR({End date})-8 > 0,HOUR({End date})-8 < 12),
MINUTE({End date}),
0))
,"min")
)
)
```

If your columns names are different from the one I use, fell free to take this code into a code editor, and Ctrl+F each references of the 4 columns and modify them with yours.

This will count hours between the “Begin” and “End” columns only for days that are setup in your working week on Monday.com (On top right click on your profile photo → My profile → “Account schedules”)

If you want more details on how it works to modify it, feel free to add a reply on this topic and I’ll answer whenever I see it.

Hi everyone!

Have you ever faced the problem of tracking the team effectiveness? It’s a popular request from Monday users. I would like to share a great news with you to make the workflow process even more convenient

Our team has presented Time in Status add-on which helps to track time the item has spent in each workflow status easily. So you can monitor how fast the item moves between statuses. Great, isn’t it?

You’ll get user-friendly data on the board in a few seconds.

You can try it on the Monday Marketplace and share your experience with us.

Hope you find this add-on helpful.

Hi there

I am happy to announced that we realised Time in Status app which track time the Item has spent in each workflow status. So you can monitor how fast the Item moves between statuses using app with reports.

You’ll get user-friendly data on the board in a few seconds.

Also you will be able to track how much time your issue spends in each status and much more by generating 3 types of reports:

And use **charts** to visualize your reports a sample of a certain number according to time range/item range, or a **single** **item**:

**Pie Charts****Bar Charts****Area Charts**

The app is also available in the format of board integration.

You can try it on the Monday Marketplace and share your experience with us.

Hope you find this app helpful.

1 Like

Hi @BiancaT - I tried using the {PM Hours#Hour} formula to get the summation for total number of hours. However, the results seem to be multiplied.

e.g 30min = 1800 (looks like they are taking the data * 60)

Is there something wrong with how i am applying the formula?

Hi everyone,

I totally understand the frustration around trying to automate SLA timers within Monday, especially for those of you who have specific needs, like starting and stopping timers during business hours. After spending quite some time working through the Monday API, I’ve managed to build a reliable solution that automates this process **without needing constant manual input**.

The system I’ve developed ensures that:

• Timers start automatically at the beginning of the workday for items with specific SLA conditions (e.g., Business Hours).

• At the end of the day, timers are automatically updated, and tasks are properly tracked based on the SLA status.

It’s built to work seamlessly with Monday’s boards, even handling different workflows without you needing to worry about keeping track of everything manually.

If this sounds like the solution you’ve been looking for, I’d be happy to chat and implement it for you. It’s a tailored solution that I can customize to fit your specific use case, ensuring the automation works exactly how you need it.

Feel free to DM me if you’re interested in learning more or if you’d like a quick demo!

Also, if you want to chat via email, you can send one to sharplyapps@gmail.com, I will be answering on the same day.