Forum Discussion

JillKauffman's avatar
JillKauffman
Qrew Member
2 days ago

Need to display hours and minutes within a TAT formula

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

formulas

1 Reply

  • hueyal's avatar
    hueyal
    Qrew Trainee
    2 hours ago

    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?