Automatic Time Deduction

Platform discussions Special workflows & use cases
, , , ,
1

Hello!

I am wanting to automatically subtract 30 minutes from a time tracker column after each entry is completed. How can I do this?

2

@JaredJLY

You could start with a simple formula like this to calculate the hours worked:

{Time tracking} / (60 * 60) - 0.5

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

3

Is there a way to subtract 30min from each entry? This formula only allows me to subtract from the sum of all hours worked.

4

@JaredJLY

I understand. That is a more difficult request. The way I would approach this is to create a Make scenario to access the history subfield of the time tracking column, count the entries and use that times your 30 minutes to calculate the total time then save that result to a numbers or hour column.

It would be a little tricky as to get the history subfield you would need to create a custom GraphQL query. Something like this:

query {
  items (ids:[12341961]) {
    column_values(ids:"time_tracking__1") {
      ... on TimeTrackingValue {
        history {
          id
        }
        duration
      }
    }
  }
}

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday
What is Make & How can it help you with monday?