MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time and 3D database

Posted by Eric Martinez on September 27, 2001 12:43 PM

Well I have two problems. The first is the simple one I need excel to take two times in the 24h format and give me the time in tenths. 2106-2200=.9hours.

The second is I want to take the Vspeed charts we have to compute our takeoff vspeeds in an excel spreadsheet. there are elleven altitdues, Sea level and then one through ten thousand feet. Each sheet is broken into two main parameters weight and temperatue. The final conculsion has 4 answers V1, Vr, V2 and takeoff roll. Then I need it to compare between the altitudes, temperatures and weights. It is pretty much a 3D database.


Posted by Mark W. on September 27, 2001 1:16 PM

For your 1st problem...