How to convert a string with time (HH:MM:SS) to integer or float?

(0) Share

Report

Posted on by JoostvanDeelen

I'm trying to convert a variable with a string which contains a time hh:mm:ss to an integer or float that can be used to make calculations. I've searched and tried different solutions but found no solution to this issue. Does anyone know how to do this?

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @JoostvanDeelen,

The ticks function is pretty useful for this in Power Automate.

Below is an example of such a calculation with three expressions.

Start Time

ticks(formatDateTime('14:01:22', 'HH:mm:ss'))

End Time

ticks(formatDateTime('14:31:22', 'HH:mm:ss'))

Calculating time difference in minutes

div(sub(outputs('Compose_-_End_Time'),outputs('Compose_-_Start_Time')),600000000)

Was this reply helpful? Yes No