Hi everyone,
The screenshot above shows a side-by-side view of two sheets from the same workbook.
On the left, I have a Duration field with the formatting h:mm which is displaying the data correctly.
On the right, I have a Link to Table field linking to the data from the sheet shown on the left, and then a Lookup field retrieving the data from the Duration field mentioned above. However, the data is now displayed in seconds instead of the desired format h:mm (as seen in the Edit Field popup window).
I've tried changing the duration formatting in both sheets but the issue persisted i.e. the sheet on the left respects the formatting I give it, but the sheet on the right keeps displaying the data in seconds no matter what.
Is this a known issue?