function formatTime & formatDuration ---> invalid double

[LipuFerrara]

Sorry, I don't speak english very well.

I have a problem in my database.

field "one" => 08h:00m

field "two" => 10h:00m

field "three" => formatTime(#{two} - #{one}) = invalid double 03:00 WHY 10-8=3? WHY INVALID DOUBLE?

field "four" => formatDuration(#{two} - #{one}) = invalid double 02:00 WHY INVALID DOUBLE?

I have an LG G2 with Android 5.0.2 and Memento Pro 3.9.6

Bye bye,

Davide

[Eugene Kartoyev]

Under the formula, right after the preview, you have the menu for result type. The result of Format- duration/time is *string*. But your result menu is set to *double* or similar. Change it to *string* type and it will work.