Answered

How to chage Time value (Format = 08:00:00 in Excel but Showing on power app = 0.33333333)

(1) Share

Report

Posted on by thanakitKK

Hello, Expert power App developer

I can't change value of Time from Excel Database (Value = 08:00:00) and showing on power app (Value = 0.3333333) //See detail in Picture 1) and Excel Database in picture 2.

I want to change it to HH:mm format.

Thank you for kindly help

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
hey @thanakitKK

can u try this:

Text(ThisItem.'Start at', "hh:mm")

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
thanakitKK 18 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello , @mmbr1606
It didn't work.
Verified answer

WarrenBelz 156,538 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @thanakitKK ,

A bit tricker than you might think - this seems to work

With( { _Time: Round( YourTimeNumber * 24, 3 ) }, With( { _Hours: RoundDown( _Time, 0 ) }, _Hours & ":" & Text( Mod( _Time, _Hours ) * 60, ".00" ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
thanakitKK 18 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello, @WarrenBelz
Wow, That's really great special Thanks for your kind help of you both @WarrenBelz @mmbr1606
I'm testing your formular that work but has a little bit problem seem like the picture:

Some Item isn't exactly time and value has missing.
WarrenBelz 156,538 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

@thanakitKK ,

You did not say you wanted seconds - that is a whole new level of complexity.
thanakitKK 18 on at

Like
a
(1)

Report
Copy link

Link copied!

@WarrenBelz
Yes, You are right.
Thank you for your kind help, I will practice more to skillup and will help other like you.