PPRuNe Forums - View Single Post - Excel 2007 Formatting Problem
View Single Post
Old 27th May 2011 | 11:24
  #2 (permalink)  
MacBoero
15 Anniversary
 
Joined: Jan 2008
Posts: 300
Likes: 0
From: London, England
The reason you're having a problem is because the cell formats for date and time operate on a system time value. When zero this equates to midnight or 1st of January 1900. Each increment of 1 adds a day, i.e. 24 hours.

The value you are using being hours, is being counted as days, i.e. 24 times too much, so divide by 24.

A1=134
A2=9.58
A3=A1/A2/24
Format cell A3 to HH:MM:SS gives 13:59:15

Hope that helps.
MacBoero is offline  
Reply