Uploaded February 2023 | Updated November 2026, 5 days ago
In summary, the Excel TIMEVALUE function is a useful tool for working with time data in spreadsheets. It converts text strings that represent times into serial numbers that can be used in calculations. To use the function, enter the text string into the function's parentheses and make sure the string is formatted correctly
--------------------------------------------------------------
๐ ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
๐๐ป Like Facebook Page :
facebook.com/ExcelExciting
๐ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #excelshorts #excelshortsvideo #spreadsheet #microsoftexcel #excelformulasandfunctions #excelformula
In summary, the Excel TIMEVALUE function is a useful tool for working with time data in spreadsheets. It converts text strings that represent times into serial numbers that can be used in calculations. To use the function, enter the text string into the function's parentheses and make sure the string is formatted correctly
--------------------------------------------------------------
๐ ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
๐๐ป Like Facebook Page :
facebook.com/ExcelExciting
๐ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #excelshorts #excelshortsvideo #spreadsheet #microsoftexcel #excelformulasandfunctions #excelformula





![How to filter Min & Max Value (Power Query - Excel & Power BI)
In this video we will use a simple trick to filter max or the largest value in Power Query for Excel and Power BI, it not limited to the max value, but you can easily filter min or smallest value in power query. The steps remain the same.
00:00 Introduction
00:20 Understand the problem
01:07 Voting for the idea on Excel User Voice
01:27 Explaining the solution
03:44 Error handling in Power Query
04:13 Max & Min Value
06:00 Testing the solution
06:40 End Screen
๐ณ Voting Link
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/42487501-power-query-number-filter-option-to-have-maximum-o
๐ Download the file here
https://excelexciting.com/how-to-filter-max-or-min-value-in-power-query-for-excel-power-bi
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ปLike Facebook Page:
https://www.facebook.com/ExcelExciting/
๐ฅJoin the Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Extract Multiple Matching Records
https://youtu.be/pTVxxaZQx24
Learn how to use Microsoft Flow / Power Automate
https://youtu.be/HQyxnPYW9Jc
NON-VBA Solution Convert Number to Words in Microsoft Word [mac & windows]
https://youtu.be/W1Ghyp6Rla0
Excel with 41Million+ Records & still why UK has Data Loss of COVID-19 Cases?
https://youtu.be/YVMTgZsRCGQ
***********************************************************
#Excel #PowerBI #PowerQuery #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForWindows #ExcelTricks How to filter Min & Max Value (Power Query - Excel & Power BI)](https://i.ytimg.com/vi/icqkXRzKe98/mqdefault.jpg)




