PPRuNe Forums - View Single Post - Excel 2007 Formatting Problem

3rd June 2011 | 15:41

#7 (permalink)

Duckbutt

Jack's Granddad

Joined: Jun 2003

Posts: 623

Likes: 0

From: Lancashire

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

0