Example: Job Duration Calculation
This online database template calculates job duration between two dates, considering weekends, holidays, and working hours.
Description
The Calendar table contains the records of the working days including working hours as well as holidays.
When creating a task you can specify the start date/time and end date/time for the task. The system automatically calculates the task duration excluding non-working hours or holidays/weekends.
See blog article for detailed explanations.
Screenshots
To help you make the system work for your needs, we have developed the following service program:
- Discuss your needs with our staff.
- We’ll determine and confirm the workflow logic of your database.
- We’ll create a ready-to-use database to fit your exact business model.
- You’ll get a solution designed especially for your needs.
Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.
We offer free system configuration assistance
(up to 4 hours of consulting work).
If you decide that our database is not exactly what you need - you owe nothing.