Skip to main content
Question

Destination hous

  • December 6, 2022
  • 0 replies
  • 9 views
Good morning, please help me:
Need to calculate the number of hours from two date/time values: [Job Ended] and [Job Started]
Looked at examples in the search, found something formula. But the formula does not work. Empty value:

ToHours(([Job Ended])-([Job Started]))

What am I doing wrong?

------------------------------
Dmitriy Serebrennikov
------------------------------

Ready: ToHours([Job Ended]-[Job Started])
      This topic has been closed for replies.

      MarkShnierYou
      Forum|alt.badge.img+22
      • MarkShnierYou
      • Quickbase Alumni
      • December 6, 2022
      Is the field type formula numeric?  On your test record are the start and end date time fields populated?

      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
      Mark Shnier. Your Quickbase Coach
      Forum|alt.badge.img+15
      • DonLarson
      • Quickbase Alumni
      • December 6, 2022
      [Job Ended]-[Job Started] is a Duration.   You cannot convert it to Hours.   That works on a number like ToHours(8)  gives you a Duration of 8 Hours.

      Your formula field to be set to display Hours as the units.



      ------------------------------
      Don Larson
      ------------------------------
      Terms & ConditionsAccessibility statement