Hi all,
I am using the get data from web function and then editing the queries.
I am pulling data from a workbook I can not edit. One of the columns data is a custom format [hh]:mm, unable to change this at source. Once the query pulls the data is changes the value.
Example:
Source cell 1184:00 (formatted as custom [hh]:mm) on the queries editor it shows as 49.333333 and format I chose doesn't revert it back to display 1184:00.
Is there a way of setting custom format like in excel?
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Welcome to the Forum May90!
What is the format you chose?format I chose doesn't revert it back
Please attach the file and tell us which cells to look at. See yellow banner at the top of the page.
49.333 is in days. You have to multiply with 24
Excel dates are just in units of days. You can multiply by 24 to get the number of hours, or just format as [hh]:mm if all you care about is how it's displayed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks