Skip to main content
Solved

Calculate # of Hours between Start and Stop time

  • October 17, 2019
  • 0 replies
  • 80 views

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

Best answer by MarkShnierYou

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------

Forum|alt.badge.img+15
  • Registered
  • October 18, 2019
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
------------------------------