Time field showing incorrectly

[#1]

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

[swuehl · Accepted solution]

Use interval() instead of time() to format time intervals exceeding 24 hours:

=interval(closedate-logdate)

[tresesco]

Try with interval(), like:

interval(closedate-logdate , 'hh:mm')            // you can define your format (hour/min) as expected

[nilesh_gangurde]

Hii,

If you subrtact the Directly (closedate-logdate) , it will give u the difference in Days. those days you have to convert into Hours.

hence the output is showing wrong results.

-Nilesh