Comments for Confessions of a twenty-something http://bethaney.co.uk/blog Athiest.Biologist.Bookworm.Student.Partner.Friend Fri, 02 Jul 2010 20:41:27 +0100 http://wordpress.org/?v=2.8.1 hourly 1 Comment on The Application: The End by Craig Mayhew http://bethaney.co.uk/blog/?p=104&cpage=1#comment-160 Craig Mayhew Fri, 02 Jul 2010 20:41:27 +0000 http://bethaney.co.uk/blog/?p=104#comment-160 you should update this with a more upto date and positive blog post. you should update this with a more upto date and positive blog post.

]]> Comment on Excell mm:ss.00 to ss.00 by Bethaney http://bethaney.co.uk/blog/?p=12&cpage=1#comment-3 Bethaney Fri, 10 Apr 2009 09:41:08 +0000 http://bethaney.co.uk/blog/?p=12#comment-3 If your system automatically produces numbers in the sss.00 format and excel "knows" that these numbers are seconds and milliseconds, then simply format those cells to [mm]:ss.00. <p>If however, the cell is simply ###.## - just a number, it becomes a little more complex. I've had a play around and I have come up with the following formulae which you need to place in the cells in which you wish to display mmm:ss.00 :</p> <i><b>"=CONCATENATE(INT(G8/60),IF(MOD(G8,60)<10,":0",":"),FIXED((MOD(G8,60)),2))"</b></i> where g8 is the cell with the no. of seconds in it. There is unfortunately no simple way of doing it, but this will work on any number in seconds eg. 12432.968. It also works around a known excel bug which likes to produce strange numbers when not asked, ie can return 3.999999999 instead of 4. Hope this helps and let me know if you have any problems with it and I will see what I can do! Bethaney If your system automatically produces numbers in the sss.00 format and excel “knows” that these numbers are seconds and milliseconds, then simply format those cells to [mm]:ss.00.

If however, the cell is simply ###.## – just a number, it becomes a little more complex. I’ve had a play around and I have come up with the following formulae which you need to place in the cells in which you wish to display mmm:ss.00 :

“=CONCATENATE(INT(G8/60),IF(MOD(G8,60)<10,":0",":"),FIXED((MOD(G8,60)),2))"

where g8 is the cell with the no. of seconds in it.

There is unfortunately no simple way of doing it, but this will work on any number in seconds eg. 12432.968. It also works around a known excel bug which likes to produce strange numbers when not asked, ie can return 3.999999999 instead of 4.

Hope this helps and let me know if you have any problems with it and I will see what I can do!

Bethaney

]]> Comment on Excell mm:ss.00 to ss.00 by Doug http://bethaney.co.uk/blog/?p=12&cpage=1#comment-2 Doug Fri, 10 Apr 2009 04:35:58 +0000 http://bethaney.co.uk/blog/?p=12#comment-2 This is exactly what I'm looking for except I need to go the other way. I have a timing system that gives me sss.00 and I need mm:ss.00. Any idea how to do this? Cheers, doug This is exactly what I’m looking for except I need to go the other way. I have a timing system that gives me sss.00 and I need mm:ss.00. Any idea how to do this?

Cheers,
doug

]]>