PPRuNe Forums - View Single Post - hour calculator
Thread: hour calculator
View Single Post
Old 13th Jan 2012, 17:04
  #5 (permalink)  
mutt
 
Join Date: Sep 1999
Location: ME
Posts: 5,502
Likes: 0
Received 0 Likes on 0 Posts
Try this

=(A4-INT(A4))*24

Make sure column A is HH:MM then put the formula in column B, (This can be hidden later)

You can add the figures in column B normally as they are decimals, lets say..

=sum(B1:B10) this is in B11. If column A11 = B11, you will get a HH:MM total.

I'm sure that there are other ways, but this works.

Mutt
mutt is offline