Excel shizzle.

Need a hand with a home project, how to fix that bloody roof leak, hang a door etc...
Post Reply
User avatar
norbs
fucking right wing vegan lesbian
Posts: 24178
Joined: Fri Dec 17, 2004 6:01 pm
Contact:

Excel shizzle.

Post by norbs »

Any Excel gurus here?

I am doing some analysis of the ride on Sunday. Spat all the GPS data into a spreadhseet and want to work some shit out.

I need help with 2 things.

How do I subtract one time from another to give me the time taken between 2 points if the time is in this format.

16/10/2011 8:56:55 AM
16/10/2011 9:31:51 AM

That is all in the one cell.

And, each line of the spreadsheet has a distance travelled value that has an m for metres on it. eg: 2 m

I tried to add them all up and it gave me zero. Is there an easy way to strip all the "m"s from that cloumn so i get a value?

Thanks.
Sarc ; my second favourite type of gasm.
User avatar
Vilante
Master artist
Master artist
Posts: 9336
Joined: Thu Jan 05, 2006 9:32 am
Location: Sydney - Australia

Re: Excel shizzle.

Post by Vilante »

Data --> Text to columns will sort the second one. Select Delimited then on the next frame 'other' and put in an 'm'.

The first one I'm sure you can do the same way, let me have a much around.

Edit - Yeah do the same thing to seperate out the time only and you can add or subtract it etc.

If I haven't explained well Google a walk through on Text to Columns.
User avatar
norbs
fucking right wing vegan lesbian
Posts: 24178
Joined: Fri Dec 17, 2004 6:01 pm
Contact:

Re: Excel shizzle.

Post by norbs »

Vilante wrote:Data --> Text to columns will sort the second one. Select Delimited then on the next frame 'other' and put in an 'm'.

The first one I'm sure you can do the same way, let me have a much around.

Edit - Yeah do the same thing to seperate out the time only and you can add or subtract it etc.

If I haven't explained well Google a walk through on Text to Columns.

Fucking champ! Thanks Mando.
Sarc ; my second favourite type of gasm.
Post Reply