3 Replies Latest reply: Dec 17, 2013 7:08 AM by Nilesh Gangurde RSS

    Time field showing incorrectly

      Hi,

       

      I have an issue with a time field.  I am trying to compare log date (eg: 01/11/2013) against the closed date (eg: 27/11/2013).  The expressions shows as such: =Time(closedate-logdate).  This gives me my backlog in hours, however as per the above example, it shows as 05:19:21 instead of showing as  600:00:00 hours (as an example)

       

      Regards,

       

      Jon Ditchfield