Archive for March, 2009

The Application: Nearly over

Sunday, March 22nd, 2009

So, have had a no from Penninsula now as well. Results were ok, but yet again it looks like June will be resit city. The lack of responses is awful as most people have secured their places, applied for finance and even got their accommodation. I am just maintaining my vision and trying to keep up with my goals.

I am due to start volunteering at Chestnut Tree House  - a children’s hospice which should be an incredibly humbling experience and I can’t wait.

Just making sure I have things (definite things) to look forward to really helps to ignore the lack of offers etc, although with my grades as they are, it is hard to imagine getting in even if I do get an offer. But, the lack of offers makes it hard to work hard. It’s a bit circular really.

Keep on going.

Excell mm:ss.00 to ss.00

Wednesday, March 11th, 2009

In order to convert time in hours:minutes:seconds.milliseconds (hh:mm:ss.00) in excel, simply set the cell format to “[ss].00″. This is a custom format.

Make sure that you have enough s’s to cover the number of seconds there will be. e.g if the format is [ss].00 and your data is 3 minutes, then although you have 180 seconds, this will only appear as 80.00. If the cell format is [sss].oo you will get 180.00

Took me an age to figure out without the use of muliplication!

Gadzooks.

Over and out!

Microsoft Word – check!

Sunday, March 8th, 2009

This might be common knowledge, bu-ut as it took me hours (read as “15 long minutes”) to figure it out, I thought I’d share the wealth!!

In order to insert a tick into your word document, you need to go to Insert -> Symbol and then change the font to any variation of wingdings, and find yourself a tick!

Obvious now, but wasn’t when I desperately needed one.

Sigh.

Over and out.