Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 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
7 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
7 years ago
Late response (extended weekend).  Appreciate the guidance.

Yup, my calendar entry was simply 'Date'...and as soon as I read your reply reminding me of the hour aspect, I felt stupid.

I changed the field to 'Date / Time' and it works great - thanks again for the help!