Rusty Nuts Posted May 30, 2006 Posted May 30, 2006 how can i add time to display total as total number of hours regards shindha Quote
John Loudon - Sponsorship Liaison Posted May 30, 2006 Posted May 30, 2006 Add another column, do a calc to convert time to minutes, sum it and then divide by 60 to convert back to hours Quote
neilb Posted May 30, 2006 Posted May 30, 2006 IF you format the cells as time they will add up or you can use decimal time, that's how pilots do it. Quote
Rusty Nuts Posted May 30, 2006 Author Posted May 30, 2006 thanx or use a custom to add [h}mm.ss Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.