Having difficulty converting hours to acceptable FME format

by Jak2929   Last Updated July 11, 2018 23:22 PM

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:

  1. 1:44
  2. 0:34
  3. 45:44
  4. 223:44

i.e 223 hours and 44 minutes needs to read 13424 minutes.

Any advice on transforming these values?

Related Questions

Importing dwg file to Arcgis with symbologie

Updated July 24, 2017 11:22 AM

FME: Why does AttributeRenamer cut data type width?

Updated November 10, 2017 08:22 AM

Adding index to FME MapInfo FeatureWriter

Updated July 01, 2017 16:22 PM

FME workflow not outputting tab file correct

Updated June 29, 2017 16:22 PM