Skip to main content
Question

Need to display hours and minutes within a TAT formula

  • August 21, 2025
  • 0 replies
  • 193 views
Forum|alt.badge.img+1

I am using the formula below for a duration TAT.  I have checked off the HH:MM:SS for the type and it is still displaying 0:00:00 for things that are one hour from rec'd to acknowledged time entered

Days(WeekdaySub(ToDate([Acknowledgment Date/Time]),ToDate([Communication Received Date/Time])))

 

Do you have any suggestions on how to get the TAT to display accurately?

Thank you

Jill

Forum|alt.badge.img+9
  • hueyal
  • Quickbase Alumni
  • August 22, 2025

The reason you are getting 0 for the one hour duration between the two date/time fields is the formula converts both date/times to days.  Assuming both are on the same date, the conversion to date results in 0 days difference between the two.  Also, using Days at the beginning of the formula will return days (not hours).

What is the data type of your formula field?  Can you share a screenshot?  

Mez
Forum|alt.badge.img+7
  • Mez
  • Quickbase Alumni
  • August 25, 2025

Could you just subtract rec'd from ack?

[Acknowledgment Date/Time] - [Communication Received Date/Time]

Forum|alt.badge.img+1
  • JillKauffman
  • Author
  • Quickbase Alumni
  • September 17, 2025

Here is the screen shot of the field...sorry for the delay got pulled into a bunch of stuff!  If you have a suggestion would love to hear it!

Terms & ConditionsAccessibility statement