Power Platform Community Forum Thread Details

Good evening,

I am not sure if this is the correct spot to post this, but here goes.

I am trying to set up an import of data from an API. The problem I have is to do with calculating (within Power Automate) the hours spent between times provided by the API. The format the data is being received in is:

"TimeIn1": "09:35",

"TimeOut1": "04:00",

"TimeIn2": "09:45",

"TimeOut2": "04:00",

and so on. Since there is a varying amount of times in and out, I find it quite difficult to wrap my head around it, secondly the problem is calculating the time between each TimeIn and TimeOut.

I would be greatly thankful if someone could assist in this.

Thank you,

Krys

Categories:

General topics