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?