Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-24-2023, 03:36 AM
cwkotch cwkotch is offline Millibar to barometer inches of mercury formula? Windows 10 Millibar to barometer inches of mercury formula? Office 2019
Novice
Millibar to barometer inches of mercury formula?
 
Join Date: Oct 2015
Posts: 15
cwkotch is on a distinguished road
Default Millibar to barometer inches of mercury formula?

I've read and re-read the National Weather Service's formula to convert millibars to inches of mercury, however, trying to get something to work in excel is beyond my scope of simple formulas. I have searched many sites for help, but it seems nothing is out there. Anyone know of any hidden formulas someplace?
Reply With Quote
  #2  
Old 10-24-2023, 05:53 AM
ArviLaanemets ArviLaanemets is offline Millibar to barometer inches of mercury formula? Windows 8 Millibar to barometer inches of mercury formula? Office 2016
Expert
 
Join Date: May 2017
Posts: 857
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Google says, that
1 inhg = 33.863886666667 millibar,
or 1 millibar = 0.02953 inhg
Reply With Quote
  #3  
Old 10-24-2023, 06:15 AM
cwkotch cwkotch is offline Millibar to barometer inches of mercury formula? Windows 10 Millibar to barometer inches of mercury formula? Office 2019
Novice
Millibar to barometer inches of mercury formula?
 
Join Date: Oct 2015
Posts: 15
cwkotch is on a distinguished road
Default Yes, thank you..I saw that

and I tried...I must be doing an incorrect formula, or incorrectly.
Reply With Quote
  #4  
Old 10-24-2023, 11:14 AM
p45cal's Avatar
p45cal p45cal is offline Millibar to barometer inches of mercury formula? Windows 10 Millibar to barometer inches of mercury formula? Office 2021
Expert
 
Join Date: Apr 2014
Posts: 855
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

In cell A1 have your millibar value.
In any other cell, the formula:
=A1*0.02953


If you wanted to be silly and use Excel's built-in conversion function:
=CONVERT(CONVERT(A1,"hPa","mmHg"),"mm","in")
Reply With Quote
Reply

Tags
barometer, milibar, weather

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Measurement from inches to feet jcreek Visio 1 03-13-2022 07:01 PM
Millibar to barometer inches of mercury formula? Blank page is 11 1/2 Inches Wide aerophil Word 8 10-07-2021 04:47 PM
Millibar to barometer inches of mercury formula? Margin slides out to 19 inches when I save RandWald Word 2 06-01-2015 02:58 PM
Width in cm/inches in HTML file JM-R Word 0 09-08-2014 09:28 AM
Character Spacing Conversion to Inches cheech1981 Word 12 08-04-2012 07:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft