Dynamically calculated durations
I want to calculate duration in days, based on start date and end date. Is that possible? - The usecase is to build a simple report that adds up the number of days of leave taken by team members.
There seems to be no way to automate creation of a duration from date/time stamps, and the manual field for inputting a Duration is limited to hours, minutes, seconds - it does not support days.
Hey David, Johan and Paul,
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:
/Sara - PodioComment actions
We use a number field called "Number of work days".
That allows us to calculate number of leave days taken in reports.
I know it sounds great to have a calculation that automatically works out the number days between a start and end date... but what about weekends? Public/bank holidays? I.e. if I put in a leave start date that's a Thursday and leave end date that's the following Tuesday... surely I'm only taking 3 or 4 workdays (depending on whether the end date is inclusive/exlcusive) - you wouldn't want the app to add in the 2 weekend days as well.
So we use both a date and number field:
- "Dates" date field in order to visually see who is away on the calendar view
- "Number of work days" number field for the leave taken calculation
Please sign in to leave a comment.