PPRuNe Forums - View Single Post - Excel Time Calculation
View Single Post
Old 29th Jul 2005, 11:38
  #2 (permalink)  
MadsDad

(a bear of little brain)
 
Join Date: Aug 2001
Location: 51 10 03.70N 2 58 37.15W
Age: 75
Posts: 273
Likes: 0
Received 0 Likes on 0 Posts
Format the cells with the cells (say column a) as a number and the cells with the time as 'hh:mm'. So we then have, say, column A formatted as num, 2 dec, and column b as hh:mm. In column c row 1 (or wherever) use the formula '=A1/(B1*1440)'.

(Results then would be, A1 = '40.00' (i.e. £40), B1= '1:30' (one and a half hours) C1 would then be '0.44' (i.e. 44p per minute).
MadsDad is offline