Time custom field
Gabriel Tapias
It would be great to have a separate Time field, not necessarily part of the date field.
Log In
Shahen Halebian
The current time tracking feature is decent, but it would be far more useful if the tracked time could be added to a custom field. This would allow us to use formulas with time tracked, time estimated, and other values to calculate key metrics for our teams. Right now, the only way to access time tracked data is through dashboards, which offer limited options for building detailed metrics. Adding time tracking as a custom field would open up many more possibilities.
Caroline Ginty
Merged in a post:
Custom Field Time Estimates
D
Dominik Gisler
Having the option of adding additional time estimates as custom fields would help us to manage the clients workload.
the Number Custom Field does not work, as it does not sum up / rolup from the subtasks.
Caroline Ginty
Merged in a post:
Custom time estimation field
ned
It would be really nice if it was possible to add a separate time estimation custom field.
At the moment, time estimation is used across the entire workspace, which means that there's no way to do multiple levels of time accounting. e.g. we use time estimation for day-to-day tasks, but we would also like to be able to use it for high-level project tracking. Unfortunately this ends up double-counting time for lots of users.
We could use sub-tasks, but we find they become unwieldy quickly if you have 50-100 top level projects each with 20-50 sub-tasks.
It would also be nice if the display units on the time estimation field could be changed, e.g. from hours to days, weeks, or months.
Caroline Ginty
Merged in a post:
Add Custom Field Type: Time
J
James Guitard
There's a missing functionality for custom fields: Time values. The current system field 'Time Estimate' already uses this data type, so really I just want to use the same data type for custom fields.
This is important to track task data on things like "Time Budget", and create formula field calculations that compare a custom Time field to the system 'Time Estimate' and 'Time Tracked' fields.
R
Ronei Marques Martins Junior
As a consultant, I need a Time field to set the amount of hours a feature was sold for, which can be different than the estimate.
T
Trish Ellis
Yes! We use time estimate right now, but it doesn't have seconds. We pay for how long an audio file is. So now we have to round. It's not a big deal, but we're rounding up so we're not under paying people, but now we'll def lose some money with all the rounding. Also, it's not a "time estimate" - it's truly how long the audio/video is, so we'd love to rename this field.
Rudá Moreira
YES PLEASE! I need to estimate a task and still compare this time with the sum of all estimates from its subtasks!
I'm using a number colllumn and just droping a number there if it were hours :(
Alex Nascimento
I don't know why ClickUP doesn't have this yet, it would be very useful in Task Management.
It would be much simpler if a custom field could accept:
hh:mm:ss (Hours, minutes and Seconds)
hh:mm (Hours and Minutes)
mm:ss (Minutes and Seconds)
hh / mm / ss (Hours, Minutes and Seconds only)
**Minutes and Seconds go up to 60, hours go up to 24, and after 24 it could be 1 day, or not... All of this could be configured in the Field.
With this, it would be possible to create a Field with a Formula to do this calculation, as is possible with dates.
The Date field itself could be Date and Time, and allow a date with hours, if configured like this, and the field above would be just the Time field.
Caroline Ginty
Merged in a post:
Custom Field Type: Time
Courtney Hernandez
We need a custom field for the budget time for projects and services.
Currently, ClickUp comes with a built-in time field called "Time Estimate" which is used for capacity tracking.
We're using a custom number field and inputting 1 = 1 hour or 0.33 = 20 mins
It would be nice to have the option to add custom "time" fields for those of us who track services by labor hours and can easily input budget time vs estimated time.
Estimated time fluctuates as projects and progress continue so it's not a steady use of tracking the project's budget time.
We need a budget time field that can be used as the fixed labor time the overall project was sold for.
We used to use the Time Estimate column to accommodate this need, however, because ClickUp uses Time Estimates as the metric for tracking workload and capacity it didn't work correctly for pulling accurate capacity workloads.
Example: We could sell a website and create the task with 32 hours in the time estimate for the project.
As the project progressed our team would have 28 out of 32 hours done, but ClickUp capacity reports would still see the person has 32 hours assigned to them even though they've completed 28h over the span of weeks working on it.
I reached out to support, they suggested deleting the 32-hour time estimate and changing the time estimate on the project to 4 hours in order to get accurate capacity tracking for the employee working on it. This method would mess up our fixed project budget need.
So because of this, we've changed all of our Budget Time tracking that was on the "Time Estimate" field to a number field.
We're using the number field right now to accommodate this, but it's not the best fit.
- There is no roll-up in number fields, so we can't see the overall sum of the budget should additional items be added as a parent and subtask style.
- There is no hours and minute display. The numbers can only be written in decimals, instead of the team easily seeing hours and minutes on projects.
Caroline Ginty
Hi Courtney Hernandez - Have you explored doing this using both the Time Estimate (e.g., to put in the 32 hours), as well as the Time Tracked field (to put in the time that has been put toward it)? Time tracked field supports rollups from subtasks. You could then use a Formula field to dynamically update how many hours are remaining (Time estimate - Time tracked). Let me know if that might help!
Courtney Hernandez
Caroline Ginty
I have set up formulas that allow me to create a budget hours output based on the hourly rate and service cost. I do love that your team made it possible to calculate custom formulas in the column and add them to dashboards now.
We did run into an issue with some of the custom field updates. Any formula that is a string, or has been converted into hours / minutes (rather than displaying a decimal) does not sum/calculate in the column.
I reached out to support about this and they confirmed it does not work. see the screenshot below.
I've also attached a screenshot of the custom formula fields i'm using to calculate hours and minutes for budget hours and budget left. Again they do not sum or calculate on the column.
I'm hoping that to make everyone's lives easier, ClickUp could create an option as a "+ create field" that ClickUp users can add to their workspaces. It would look like and function like the Time Estimate column, except for this create field option does not have anything to do with overall capacity tracking and more to do with custom project time budget tracking many of us need.
Adding a custom field type that we can input time (just like we can do with Time estimate) seems like the easiest solution for all of us users who need to accurately track time budgets on projects.
Pierre Becher
Courtney Hernandez looks great. how did you convert the hours into h:mm format? iny my formula it shows up as decimal numeric value
Courtney Hernandez
Pierre Becher Hey Pierre,
It is done by converting the decimal into hours and minutes by multiplying the decimal by 100% of an hour and adding the "h" and "m" text indicators to break up hours and minutes in the output.
Example:
0.01 = 1% of 100%
100% of an hour is 60 (minutes).
You'd build your formula based on converting decimal hours into time by calculating by 60.
For example here is an example of a formula I used. This will be different for you to adjust based on the fields you need to calculate your budget time from.
Example Formula (Budget Hours):
ROUNDDOWN(field("Service Fee") / field("Hourly Rate"), 0) & "h" & " " & ROUNDDOWN(MOD((field("Service Fee") / field("Hourly Rate")) * 60, 60), 0) & "m"
NOTE: The issue with this in ClickUp tho is that once you convert a decimal time output into a time output with "h" and "m", for some reason ClickUp no longer sums the column anymore. I'm hoping that this will change in the future as it will be helpful for our company to see overall budget hours owed and left in each list easily.
To (hopefully temporarily, if ClickUp updates/improves this) navigate the lack of sum for time formulas, I've left a decimal version of the "budget left" for our team at Long Point Digital to still use and see a total sum when needed.
hope this helps in your task management process improvements! :)
Pierre Becher
Courtney Hernandez Awesome, thank you so much for sharing this! I will definately check it out and implement it :)
Load More
→