PPRuNe Forums - View Single Post - Excel 2007 Formatting Problem
View Single Post
Old 1st Jun 2011, 08:26
  #5 (permalink)  
MacBoero
 
Join Date: Jan 2008
Location: London, England
Age: 56
Posts: 300
Likes: 0
Received 0 Likes on 0 Posts
That won't cure the initial problem Spurlash2.

Merch's initial problem was that he was generating numbers with base units of 'hours'. I.e 13.987 hours.

The date/time field formats (even custom ones) assume base units of 'days', hence the need to divide by 24, to convert his hours into days. I.e. his 13.987 becomes roughly 0.5828 days. When this is formatted with a date/time format, the answer then comes out correctly.
MacBoero is offline