Microsoft Office Forums Millibar to barometer inches of mercury formula?
 Register FAQ Search Today's Posts Mark Forums Read

#1
10-24-2023, 03:36 AM
 cwkotch Windows 10 Office 2019 Novice Join Date: Oct 2015 Posts: 15
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?
#2
10-24-2023, 05:53 AM
 ArviLaanemets Windows 8 Office 2016 Expert Join Date: May 2017 Posts: 857

1 inhg = 33.863886666667 millibar,
or 1 millibar = 0.02953 inhg
#3
10-24-2023, 06:15 AM
 cwkotch Windows 10 Office 2019 Novice Join Date: Oct 2015 Posts: 15
Yes, thank you..I saw that

and I tried...I must be doing an incorrect formula, or incorrectly.
#4
10-24-2023, 11:14 AM
 p45cal Windows 10 Office 2021 Expert Join Date: Apr 2014 Posts: 855

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")

 Tags barometer, milibar, weather

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post jcreek Visio 1 03-13-2022 07:01 PM aerophil Word 8 10-07-2021 04:47 PM RandWald Word 2 06-01-2015 02:58 PM JM-R Word 0 09-08-2014 09:28 AM 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.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top