Skip to main content
Question

Destination hous

  • Dec 6, 2022 11:40 AM UTC
  • 0 replies
  • 19 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+24
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
------------------------------

Forum|alt.badge.img+19
  • Qrew Champion
  • Dec 6, 2022 2:04 PM UTC
[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
------------------------------