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
------------------------------

markshnier__you · 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
------------------------------

dawnrene2 · Answer

Thanks Mark! That worked! :)------------------------------Dawn Rene------------------------------

Forum Discussion

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

Related Content

Calculating number of days between two date fields

Calculation/Performance Limits Inquiry

Calculating 1.5 pay

Roundup whole number

Trying to calculate On Time delivery