Log In
Register
Home
Power BI
February 20, 2019
Offline
1. On the master table (sheet name: Tuition_August_2022), the time on the "Pickup" column is formatted as 2:50:00 PM. How can I format it as 2:50?
2. On the Pivot Pivot tables (sheet name: Pickup),
(1) the time on the "Pickup" column is formatted as 2:50:00 PM. How can I format it as 2:50?
(2) Whenever I refresh it, the time formats become "numbers," so I need to format them every time I refresh them manually. How can I keep the format consistent such as 12:50, 1:30, or 2:55?
Thanks,
Jim
July 16, 2010
Offline
Hi Jim,
The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the file size before clicking 'submit reply'.
That said, you'd need to change the number format to 24 hour time, so 2:50 PM would become 14:50 and the number format would be h:mm
If that doesn't work, please attach your file.
Mynda
Power BI
February 20, 2019
Offline
Mynda,
Here you go. Thanks.
October 5, 2010
Offline
Jim,
No file is attached.
Please follow the instructions here to upload a file
Read This First | Forum Rules and Guides | Excel Forum • My Online Training Hub
regards
Phil
1 Guest(s)
