PPRuNe Forums - View Single Post - Formatting of hours in Excel spreadsheet

25th Jan 2007, 16:32

#9 (permalink)

737TG

Join Date: Jan 2001

Location: Stansted, UK

Posts: 44

Likes: 0

Received 0 Likes on 0 Posts

You could also convert your times into decimal:

=(MINUTE(A1)/60)+HOUR(A1) [A1 is the cell you wish to convert]

ie. This converts 2:29 into 2.48

Quick and easy and much easier to work with decimal hours

Cheers!

Reply