I have an excel document with a 'time' column.
I need to get this column into an appropriate format for FME to convert the values to minutes.
The problem is that the cells are in different formats (h:mm, [h]:mm:ss).
An example of the data is:
i.e 223 hours and 44 minutes needs to read 13424 minutes.
Any advice on transforming these values?