Is Time Tracking only during work hours possible?

[supreme (Max Bridges)]

Hi,

Is there a way to limit time tracking to only business hours?

We’re using Monday for manufacturing tasks, and want to see how long each each phase tasks. Is there a way to track just the time it takes during business hours? For example, from 5pm to 9am we’d want to pause the tracking as well as on the weekends. Then when work starts again, have the tracker run.

[ops (Mark Bien)]

Has someone got back at you with your query? I am trying to do the same thing.

Any automation or app needed to run this?

[Ado84 (Adonay)]

Still seems to eb no response form Monday.com folks on this, I am trying to create an automation but no tools there seems to allow for this

there is an Every Time Period kick start command in automations. It makes you think you can state a start and stop in two automations for business hours:

• Everyday at 8am do this
• Time Track [start or stop] is not a follow up option
• Only Notify, Create Item, Duplicate Group or Create Group are options

Ideally you want:

• Every day at 8am start Time Tracker only if status Is [insert] and day is not Saturday or Sunday
• Every day at 5pm stop Time Tracker only if status Is [insert] and day is not Saturday or Sunday

[jonbowser (Jonathan Bowser)]

How do we get more upvotes here? Tracking business hours is a pretty critical element for SLAs.

Whether there’s a formal way of handling this or simply extending the time functions inside a Formula column (i.e. you can create a formula in Excel to calculate business hours based on two timestamps), we need a way of tracking and measuring time in business hours.

[Kalyani]

I came here with the same problem and it looks like its been 1 year since this was flagged but we don’t have a workaround or a solution for this.

@monday-team Could you please have a look at this?

[Rach12 (Rachael)]

I replied to a different thread and they are trying to find a formula, possibly add some feedback there as an agent said they are discussing possibilities with their team: Time Tracking - Column Summary - #17 by BiancaT

[Valeriia.H (Valeriia)]

Hi @supreme
Welcome to the community!

To see how long each each phase tasks try Time in Status app 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.
You’ll get user-friendly data on the board in a few seconds.

With our app you can easily manage Work Calendars to track just the time it takes during business hours

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

• Time in Status Report
• Status Count Report
• Transition Count Report

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.

Start the 14-days free trial to try it out for yourself and share your experience with us.

Hope you find this app helpful,
Valeriia

[benjamin.ngo]

Hi!
I found a solution, however it is quite convoluted. Firstly, on the board with your time tracking, create 2 separate date columns. 1 that is set to the current date, and 1 that is set to tomorrows date.

-then apply the following automations to the two columns

This pushes the 2 dates back 1 day. the first automation, you should set as 5:00pm and the second, set as 9:00am. This however, still applies during weekends. So what you need to do is create a separate board that mirrors to the original.

• i have a status, date and mirror column. With the date, apply the following automation.
  
  
  
  This will show the current date. For the next step, you will need the integration “general caster” to cast formulas into columns and apply this automation
  
  
  
  with this formula IF(OR(WEEKDAY({item’s IGNORE}) = 1, WEEKDAY({item’s IGNORE}) = 7), SWITCH(WEEKDAY({item’s IGNORE}), 1, “Weekend”, 7, “Weekend”, “”), “”)

Then on the original board, apply the mirror and create a mirror status with the connection. Then create this automation

Hope this helps!