Calculation between start/end times
Completed
I like the the feature of the start and end time with the date field, however, I'd like to be able to calculate the difference between them for a report - in my particular use case - this would make a much more elegant solution for time tracking. I don't like having to remember when I started on a project - I want to be able to get a report based on the difference. Also, the the "time" field could use a better implementation. It'd be nice if it even inherited a default value of the current time that you could accept with either a popover or something to that affect.
-
Official comment
Hey all,
Great news :) With the big release this week, you can now perform far more advanced calculation to the brand new Calculation field.
We have an article to explain how this works here:
https://help.podio.com/hc/en-us/articles/201019358-Calculations/Sara - Podio
Comment actions -
while a current time input would be magical, even just @Jesse Martin's suggestion would make tracking time a lot easier and a lot cleaner aswell.
My current timesheet app references 4 Projects per timesheet.
a simple calculation for start time and end time for each project would make the tracking so much easier.
I'm finding that I have to manually figure out the duration for each project, thus inheriting a seemingly avoidable margin for human error.
Also, the calculation app can only calculate two fields at a time.
I currently make a calculation for Project 1 + Project 2, then Project 3 + Project 4
and then a calculation for the sum of those two.
the implementation of this across all my staff is proving diffucult.
-
I would really love to see the ability to calculate the duration based on the start and end times. I agree that manually entering the duration leaves a lot of room for human error, and the duration field is what's used with the hourly rate to calculate billable time. I'd love to be able to calculate billable time/duration based on the start and end times. :)
-
While I agree with all of the suggestions for improvement below, I've been using a workaround that might work for some and might not have been suggested yet.
I have two duration fields: one is labeled beginning and the other ending. All time is entered in 24-hour style. (I don't use the seconds field). I calculate the difference between the ending and beginning times, which returns a decimal based upon fraction of the hour. This removes some of the human error, namely the calculation of the duration. Of course, the employee still must input the correct start and end times.
Every time I switch tasks, deliverables, or projects, I create a new timesheet. (I've renamed my app "Time Entry" to better reflect how this app is used.) Each timesheet references a different deliverable or project.
I use this calculation to then calculate how much that time cost on a billable hour basis by multiplying the employee's billable hour rate by the amount of time worked calculated above.
Hopefully this helps!
-
Hi Paul,
This should be possible using our calculation field! If you need help with the calculation I recommend to check this Forum: https://help.podio.com/hc/en-us/community/topics/200101427-Calculations
We also have a PDF guide attached in the bottom of this article with help to more complex calculations:
https://help.podio.com/hc/en-us/articles/201019358-Calculations
//Sara - Podio
Post is closed for comments.
Comments
12 comments