How to calculate the number of days it takes to do a job based on hours

Question

I have a numeric field [Total Duration Hours] that I need to convert to Days based on a 10 - hour work day. So if I have a total of 11 Duration Hours to complete a job, it will show that it will take 1 business day (10 hours) "plus" to complete.

Any thoughts?

------------------------------
Dawn Rene
------------------------------

MarkShnierYou · Answer

Try this as a formula numeric field called [# of Days]

ToHours([Total Duration Hours])/10

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community