HH:MM format not adding up correctly.

Legacy Contributor

I'm trying to display a time interval, e.g., 3.2 hours, in HH:MM format.  So 3.2 converts to 3:12.

I was successfully able to do this using:

ToTime(Integer(Format([Departure Date: Sum: Flight Time Est]*3600000,'#')), 'hours,minutes,seconds', '%d:%02d')

But then I get this error which warns me that HH:MM may not add up correctly

And indeed it does not add up correctly!  

Is there a way to get the HH:MM format where it DOES add up correctly, or is this not a functionality that is available at this time?

Diane McElhiney

This write-up may help https://community.infor.com/infor-birst/b/in-the-birst-space/posts/alternative-to-to_5f00_time_5f00_format

Also, TO_TIME_FORMAT functionality contained a regression bug which has been fixed in 7.8.1 to be deployed as the next scheduled release.