Forum Discussion

SheenaGafos's avatar
SheenaGafos
Qrew Trainee
5 years ago
Solved

Calculate # of Hours between Start and Stop time

Which formula can I use to calculate the number of hours between Start and Stop time?  The field properties is Time of Day.​

------------------------------
Sheena Gafos
------------------------------
  • Np,
    Make a formula numeric field 

    ToHours([Stop Time] - [Start Time])

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

3 Replies

  • Np,
    Make a formula numeric field 

    ToHours([Stop Time] - [Start Time])

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • SheenaGafos's avatar
      SheenaGafos
      Qrew Trainee
      Great, thank you!!

      ------------------------------
      Sheena Gafos
      ------------------------------
  • DonLarson's avatar
    DonLarson
    Qrew Commander
    Sheena,

    What is the business case?  How do you want to use this information?   There are several ways to solve this but what you do next is important to consider.

    I suggest you create a Formula Duration field and set the units to hours.

    Now you have an object where the length of time is part of the data.   if you are going to use that to calculate another piece of information that also includes time then you are ready to go.

    If you have multiple blocks of hours, add them together and then show them as total number of days, you do not have to worry about dividing it by 24.  The same group of data used over a year might add up to months of elapsed time.





    ------------------------------
    Don Larson
    ------------------------------