Hi,
I have a large number of cells with time stamps: 00:07:45 (hh:mm:ss)
What I would like to do is just show the mm - but NOT format the cell as [mm], just as a general / number '7'.......
I've been struggling with this for a while and can't find anything in the forum that's similar....
Thanks....
Try
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
LOL!!! Don't you just love the easy ones.....
Ta very much....(hangs head in shame!!!)
No shame whatsoever! It's really easy to miss / overlook the simple solutions
I've often been guilty of massively over-engineering a complex solution, only to have someone else pipe up with a single function answer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks