Unable to convert time duration

Hi ​@will_catterick 

The date/time you have defined looks a bit off. The formula %k:%M format is looking for 2 digit hour and a 2 digit hour. 14:77 then the rest is undefined. This will probably not work but try adding in seconds to look for. 2 digit second with decimal

%k:%M:%S

That might complete without errors but give you weird numbers.

Hope that helps!

When dealing with times like this (and credit to ​@todd_davis for sharing this) I find it so much easier to convert to epoch. and work with seconds. Then you’re not having to worry about overflowing minutes to hours, hours to days etc. At the end, you can convert it all back from epoch to standard time

Hey ​@will_catterick 

It might be worth checking out this post here: min, max and median time | Community It appears that the StatisticsCalculator is working fine for minimum and maximum times, however, the calculation of averages and durations is a bit more complex. 

Hope that’ll help 

Hi ​@will_catterick ,

I think the direct reason for this error is the format of the input value14773.33... did not match the specified date/time format - standard FME date/time format.

I assume that you can retrieve start datetime and end datetime for each charging from the source dataset and format them into the standard FME datetme format - %y%m%d%H%M%S.

If so, I would recommend you to perform all the calculations in seconds.

That is, calculate duration (from start datetime to end datetime) for each charging in seconds with DateTimeCalculater (Mode: Calculate Interval between Datetimes, Result Type: Seconds), and calculate sum and average of the durations too in seconds with StatisticsCalculator.

You can then calculate hours and minutes for the result values with these expressions, and concatenate them to make your required text - hours:minutes.

hours = @floor(seconds/3600)
minutes = @round(seconds) % 60 ← This expression is wrong. See the correction below.

The reason for not using DateTimeConverter here is, I thought that the total of charging durations a month could be 24+ hours. The time format %k:%M cannot describe 24+ hours.

[Correstion] Sorry, the expression for calculating minutes was wrong. Replace with this.

minutes = @floor((seconds - hours * 3600)/60)     [round down]

or

minutes = @round((seconds - hours * 3600)/60)     [nearest]