PPRuNe Forums - View Single Post - Formatting of hours in Excel spreadsheet
Thread: Formatting of hours in Excel spreadsheet
View Single Post
Old 25th January 2007 | 09:08
  #6 (permalink)  
Whirlygig

Hovering AND talking
20 Anniversary
 
Joined: Feb 2003
Posts: 5,711
Likes: 1
From: Propping up bars in the Lands of D H Lawrence and Bishop Bonner
An alternative would be to use two columns; one for hours and one for minutes. Then use the following formulae to total the columns assuming the hours are in column A and minutes in column B (assuming a listing of 20 different times to be added)

Total at bottom of minutes column
=SUM(B1:B20)-(ROUNDDOWN((SUM(B1:B20)/60),0)*60)

And total at bottom of hours column =SUM(A1:A20)+(ROUNDDOWN(SUM(B1:B20)/60,0))

Hope that helps

Cheers

Whirls
Whirlygig is offline  
Reply
0