Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Calculate Business Hours between today's date and Future Date

So I currently have a need to calculate the number of business hours (based on a 40 hour work-week) between the current date and a future date (date field "Completion Date"), not including weekends. ...
App builders
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
In that example code, the [Status Start] field is a date/time type field.  Since you have asked for business hours, then the formula needs to know the start date and the start time.

Do you have fields for the start and end or do you currently have these as separate fields for the start date and the start time and the end date and the end time.
ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

You bet - thanks for passing on it on. 

One item that I have noticed is that you do have to be specific about logging the time (in addition to date).

For example, I have it set to calculate on a 30-hour work-week, so selecting the Monday on my project start time and Friday on my project end-time SHOULD calculate an even 30 hours. (in the formula I have it set to 08:00 AM - 02:00 PM).

What I'm finding is, if I don't type in the actual time-stamp in the calendar fields (ie 06-04-2018 08:00 AM - 06-08-2018 02:00 PM) it will skew the numbers (even though the times are set in the formula).

Other than that little wrinkle, it works beautifully for me needs.