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

25th January 2007 | 16:32

#9 (permalink)

737TG

Joined: Jan 2001

Posts: 44

Likes: 0

From: Stansted, UK

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

0