|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 4th, 2009, 04:46 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
correlate a series of numbers in mm:ss to another column also in m
I would like to create a chart which shows a series of numbers in minutes and
seconds (to the hundreths of a second) that correlates to another column, also measured in minutes and seconds(and also to the hundreths of a second) by a factor of 0.93567448724. For example, the first column will start with 16:00.00 and the second column will have 14:58.25, which is 0.93567448724 times as large as 16:00.00. I've tried to use the forumla of A*B, where A is the number 16:00.00 and B is the constant 0.93567448724, but it doesn't seem to work. Any help will be greatly appreciated. Thanks. Eli -- I will do today what you won''t, so tomorrow I can do what you can''t. 
|
|
#2
February 4th, 2009, 05:16 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
correlate a series of numbers in mm:ss to another column also in m
I forgot to mention that I'm using the text formatting in the number tab of
the format dialouge box instead of the time formatting. Is this why it's not working? Eli -- I will do today what you won''''t, so tomorrow I can do what you can''''t. "ElViejoEli" wrote: I would like to create a chart which shows a series of numbers in minutes and seconds (to the hundreths of a second) that correlates to another column, also measured in minutes and seconds(and also to the hundreths of a second) by a factor of 0.93567448724. For example, the first column will start with 16:00.00 and the second column will have 14:58.25, which is 0.93567448724 times as large as 16:00.00. I've tried to use the forumla of A*B, where A is the number 16:00.00 and B is the constant 0.93567448724, but it doesn't seem to work. Any help will be greatly appreciated. Thanks. Eli -- I will do today what you won''t, so tomorrow I can do what you can''t.
|
|
#3
February 4th, 2009, 06:20 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
correlate a series of numbers in mm:ss to another column also in m
You'll need to use custom formating for times [mm]:ss.00 +-------------------------------------------------------------------+ |Filename: Mins.xls | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=71| +-------------------------------------------------------------------+ -- mdmackillop ------------------------------------------------------------------------ mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58592
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
