MS Excel question (logbook)
Thread Starter
Join Date: Dec 2000
Location: UK
Posts: 737
Likes: 0
Received 0 Likes
on
0 Posts
MS Excel question (logbook)
Sorry if this has come up before.
I've worked out how to calculate flying hours from a take off and land time (24 minus Take off plus Landing)
But when trying to total up the flying hours, after 24 hours, it goes back to 00:00
How do you get Excel to total up your flying hours?
I've worked out how to calculate flying hours from a take off and land time (24 minus Take off plus Landing)
But when trying to total up the flying hours, after 24 hours, it goes back to 00:00
How do you get Excel to total up your flying hours?
Join Date: Oct 1999
Location: Melbourne - Australia
Posts: 356
Likes: 0
Received 0 Likes
on
0 Posts
It sounds like the format of the cell where your total is located appears as time format, i.e. maximum of 23:59
Maybe you need to look at the format of that cell???
Just a punt...
Maybe you need to look at the format of that cell???
Just a punt...
Thread Starter
Join Date: Dec 2000
Location: UK
Posts: 737
Likes: 0
Received 0 Likes
on
0 Posts
Ibis & Lurk R
Thankyou for your help, but I'm already at this stage
Pigs might fly
I thought I'd almost cracked it with your help, but no. I can add up hours with your method, but adding up hours that have already been part of a former calculation (ie Take off & Land times) - it won't work for me. Could you perhaps e mail me, attaching a blank part of your log, complete with formulas?
cheers.
Thankyou for your help, but I'm already at this stage
Pigs might fly
I thought I'd almost cracked it with your help, but no. I can add up hours with your method, but adding up hours that have already been part of a former calculation (ie Take off & Land times) - it won't work for me. Could you perhaps e mail me, attaching a blank part of your log, complete with formulas?
cheers.