PPRuNe Forums - View Single Post - hour calculator
Thread: hour calculator
View Single Post
Old 13th January 2012 | 15:25
  #3 (permalink)  
UnDeterminator
 
Joined: Jun 2006
Posts: 3
Likes: 0
From: High up
It's a bit wierd but, let's say you enter 10:55 in cell A1.

In cell B1, enter the formula for conversion: =A1*24

Excel's brainless 'Intellisense' will try to display it in HH:MM format which makes no sense: You need to change the number format to Number, 2 decimal places, and you will get 10.92

This will work with huge amounts of hours beyond 24.

Good luck...
UnDeterminator is offline  
Reply