Forum Discussion

JillKauffman's avatar
JillKauffman
Qrew Member
3 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 ...
formulas
hueyal's avatar
hueyal
Qrew Trainee
2 days 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?