I have an Excel training Log that I found on the net and have adapted for my own use. Works fine for what i need.
But ... time needs to be entered in minutes for the average speed calculation to work. I would rather enter time in hh:min:sec format (01:43:56 for ex), but then can't work out how to convert that back to minutes (or preferably seconds) for the average speed calc. to work.
I need 01:43:56 to come up as "seconds" in the calculation.
Anyone know how to do this?
B
(sorry for the slightly OT post)
But ... time needs to be entered in minutes for the average speed calculation to work. I would rather enter time in hh:min:sec format (01:43:56 for ex), but then can't work out how to convert that back to minutes (or preferably seconds) for the average speed calc. to work.
I need 01:43:56 to come up as "seconds" in the calculation.
Anyone know how to do this?
B
(sorry for the slightly OT post)