Answered

Time quantity in [h]:mm:ss

(0) Share

Report

Posted on by josealcas

I have an app to display the required time to perform a task, most of this times are >24h. I have the data source from Excel in a column with [h]:mm:ss format.

I need to extract that information in the same format from Excel to PowerApps, have tried many ways and haven´t worked.

Could you please help me with an example of how to perform this requirement?

Thanks a lot!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@josealcas

Is your app seeing the column in your Excel as a text column or a date column?

Most likely seeing it as a text column.

If so, then you can use the TimeValue function to get the results in a real time value.

ex.

Text( TimeValue(yourColumnValue), LongTime24)

Will convert the text to a real time value and then display it in the long time format.

I hope this is helpful for you.

Was this reply helpful? Yes No
josealcas 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes
Thanks a lot for your help, but this didn´t work. It shows the data as 00:00

My Excel is as a text column.

Hope you can help!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@josealcas

What does the label display if you change the Text property to : ThisItem.PLANNED_HH ?

Was this reply helpful? Yes No
josealcas 8 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes
It displays like this:

Was this reply helpful? Yes No
josealcas 8 on at

Like (0)

Report
Copy link

Link copied!

Hi Community,
Can someone help me with this please?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@josealcas

Sorry did not see a notification that you responded to this thread. Did you want to continue with my help on this or put it out to others?

In general, from the picture, your time column in Excel is not coming into PowerApps as a Date/Time column. It is coming in as the Excel value of the time. Excel time values are fractions of the total number of seconds in the 24 hour period.

Using this on the Text property of the label should show you the proper time:

Text( Time(0, 0, ThisItem.PLANNED_HH * 93600), LongTime24)

Was this reply helpful? Yes No
josealcas 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes
This works nice, the results are better now, but it won´t show me the hours when the time is up to >24Hours:

For example this data is 40:00 Hours and shows 16:00Hours

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@josealcas

Use this formula:

With({_excelValue: ThisItem.PLANNED_HH}, With({_seconds:86400 * _excelValue}, With({_hours: Hour(Time(0,0, Mod(_seconds, 86400))) + (RoundDown(_excelValue,0) *24)}, Text(_hours, "[$-en-US]00") & ":"& Text(Time(0, 0, _seconds ) , "[$-en-US]mm:ss") ) ) )

Was this reply helpful? Yes No