Converting seconds to general number format

[shani]

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

 

[Damon Ostrander]

Hi shani,

I'll have to admit I don't understand your question. But if you are looking for the Excel time value corresponding to various integral numbers of seconds, you can calculate this as =n/86400, where n is the number of seconds. From this you can see that the value

0.0000115740740740741

is the value of one second as an Excel date-time value, and n seconds is simply n times this number. This is all a consequence of the fact that Excel date-time values are simply times represented in days, or units of 86400 seconds. So, for example, 1.5000000000 is simply 129600 seconds, or 1 day 12 hours.

I hope this helps.

Damon