Time format Display form Excel

(0) Share

Report

Posted on by RoyWaarts_NL

Hi all,

I have a start time and an end time in an Excel document.

If I let this come forward in a Gallery, there will be a date in addition to the time (wrong time). Example: Start 9:00 End: 10:00

How can I ensure that the correct time and only the time is displayed?

Schermafbeelding 2020-02-28 om 12.28.54.png

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Please do this check. Enter a date in powerapps and submit it to excel and pull the date back to the gallery. Check if the date change or the same.
Again I am seeing 1899 as the date in the gallery you showed. Is that the date in Excel?

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

Was this reply helpful? Yes No
RoyWaarts_NL 24 on at

Like (0)

Report
Copy link

Link copied!

Hi, Thanks for your quick response.

I have no function in my power app to save a time in my excel document.
I don't know how to make this yet.

I have a agenda in Excel for my start and end time. See image. There is no date here, just a time. I would like the app to show only the time. So that when someone opens the app can see what time an item starts and ends.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @RoyWaarts_NL ,

Do you want to only display time value regardless of date value in powerapps?

Did you set your time field in Excel like this?

If so, I've made a similar test and found that:

if you directly use "ThisItem.start" in your gallery, it will show data like this:

12/30/1899+time value.

"12/30/1899" is the default date value of Excel in powerapps.

I suggest you use Text function to format the data.

You could set the label's Text like this:

Text(ThisItem.start,ShortTime) //Text(ThisItem.fieldname,ShortTime)
Text(ThisItem.end,ShortTime)

Then the label will only display time value.

Here's a doc about Text function for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text

Best regards,

Was this reply helpful? Yes No