Discussions

Expand all | Collapse all

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

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

    Posted 09-21-2020 10:31
    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
    ------------------------------


  • 2.  RE: How to calculate the number of days it takes to do a job based on hours

    Posted 09-21-2020 10:38
    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
    ------------------------------



  • 3.  RE: How to calculate the number of days it takes to do a job based on hours

    Posted 09-21-2020 10:49
    Thanks Mark! That worked! :)

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