I hope I explain this clear enough.
I have seconds for example 0:00:01 and in another cell I have 0:00:02. I need to format these numbers to general which I know how to do. I need this as a result.
Format Differences
Time General Number
0:00:01 - 0:00:02 0.000017361111111 - 0.000017361111112
0:00:02 - 0:00:03 0.000028935185185 - 0.000028935185186
I need to figure out how to write a formula for each interval and change each second into the general number. For now I have been trying to figure this out by hand. I need to know the exact general number as each second changes in to the next.... I hope someone can help. Thanks
I have seconds for example 0:00:01 and in another cell I have 0:00:02. I need to format these numbers to general which I know how to do. I need this as a result.
Format Differences
Time General Number
0:00:01 - 0:00:02 0.000017361111111 - 0.000017361111112
0:00:02 - 0:00:03 0.000028935185185 - 0.000028935185186
I need to figure out how to write a formula for each interval and change each second into the general number. For now I have been trying to figure this out by hand. I need to know the exact general number as each second changes in to the next.... I hope someone can help. Thanks