Convert Decimal to Hours

(0) Share

Report

Posted on by ClintRB

Hi All,

Seems fairly simple however I cannot find a way to do this within a flow.

When an item is created it produces a decimal which is a percentage of a working day (8 hrs).

For example someone requests 2hrs and 0.25 is the output.

I cannot change the way the the calculation is originally produced.

I need to be able to change 0.25 to 2:00 in a flow.

Fingers crossed

Clint

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@ClintRB

Please try adding a compose data operation with the below expression

mul(0.25,8) where you need to replace 0.25 with your decimal number

Was this reply helpful? Yes No
ClintRB 91 on at

Like (0)

Report
Copy link

Link copied!

Hi @Mira_Ghaly

Thank you for the quick reply. For some reason I cannot add the specific column into the expression.

The image below is just the test I am doing. The decimal will come from a sharepoint list when in the correct flow arrangement. Currently the decimal is put into a table form the main flow so I can keep a record. WorkDays is the Table and List header.

So this would be the expression if it worked. mul(['WorkDays'],8). But it needs to be represented as 2:00 not 2.00.

Thank you

Clint

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@ClintRB
You need to add apply for each loop after the list rows in a table, then add the compose action inside the apply for each loop.

Was this reply helpful? Yes No
ClintRB 91 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Mira_Ghaly , still no joy. I have tried all sorts of configurations and nothing works.

Will continue tomorrow.

Clint

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@ClintRB

Please check below

In your compose action: please use:

mul(items('Apply_to_each')?['WorkDays'],8)

WorkDays should be your column name in your excel sheet

Was this reply helpful? Yes No
ClintRB 91 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Mira_Ghaly I will give it a try tomorrow and let you know. I think I have tried this expression but maybe slightly different. Fingers crossed.

Clint

Was this reply helpful? Yes No
Verified answer

ClintRB 91 on at

Like (0)

Report
Copy link

Link copied!

Hi @Mira_Ghaly

This has been an ordeal however finally have it working. The issue is that the decimal was a string coming from an App. So this is a small part of the flow however was what you had helped me with.

Thank you.

Clint

Was this reply helpful? Yes No