Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use interval() instead of time() to format time intervals exceeding 24 hours:
=interval(closedate-logdate)
Use interval() instead of time() to format time intervals exceeding 24 hours:
=interval(closedate-logdate)
Try with interval(), like:
interval(closedate-logdate , 'hh:mm') // you can define your format (hour/min) as expected
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