Another Excel Question - this time about "hours"
Hi all,
Looking for a bit of help with a spreadsheet I've made up to log flight hours. Basically, I want to insert takeoff time i.e. 17:45, then insert land time i.e. 00:30 and have the programme calculate the flight duration to the minute.
I've got it working so that as long as both events take place the same day, everything is fine. The trouble comes when the aircraft lands the next day and you have 00:30 - 17:45 and no total!
I'm using Excel97 SR-1 (I know, it's the company spec). Any thoughts?
Cheers
SBG