How to log Mileage?

[Gasbot]

Doing this with my 9 year old son, whom is going to be travelling most of it from his summer holiday. How do we log his journeys both uk / foreign.
Execel spreed is poosible to best way but anybody got a formual for adding miles and chains.

so far in his 1st week he done sleeper to Plymouth all cornish branches day trip onto Glasgow then sleeper to London. Railtour his Sunday.

Cheers

 

[greatkingrat]

If you have miles in column A and chains in column B

Chains Total
=MOD(SUM(B1:B8),80)

Miles Total
=SUM(A1:A8)+INT(SUM(B1:B8)/80)

Obviously you may need to change the cell references A1:A8 and B1:B8 depending on how your spreadsheet is laid out and how many rows you want to add up.

 

[Peter Mugridge]

Obviously you may need to change the cell references A1:A8 and B1:B8 depending on how your spreadsheet is laid out and how many rows you want to add up.

You can drag a formula down the rows and it'll update the cell identities automatically can't you?

 

[Gasbot]

Thank you for a quick reply

Having difficulties in setting it up. Could I send you my template and you sort out formula for me ?
Gasbot

 

[03_179]

Thank you for a quick reply

Having difficulties in setting it up. Could I send you my template and you sort out formula for me ?
Gasbot

Sure.

hetsc68 @ yahoo.com (remove the spaces)

I also have a template I use which may be of help it totals miles and against each unit/loco.

 

[gordonthemoron]

I just store it as =miles + chains/80