PPRuNe Forums - View Single Post - Excel 2007 Formatting Problem

3rd Jun 2011, 15:41

#7 (permalink)

Duckbutt

Jack's Granddad

Join Date: Jun 2003

Location: Lancashire

Age: 76

Posts: 623

Likes: 2

Received 0 Likes on 0 Posts

Possibly not QUITE what you are after but if you format the cell A3 as h:mm then enter the formula (A1*60/A2)/1440, applying the figures you supply you get the result of 13:59 in A3.

Reply