Subject: | [Shop-talk] metric time - was OT- Excel help |
---|---|
From: | fishplate at gmail.com (Jeff Scarbrough) |
Date: | Thu, 15 Mar 2012 20:39:05 -0400 |
References: | <4F61A9BA.5030407@talktalk.net> <OF5E99C812.D08CAD37-ON852579C2.0042EA8C-852579C2.00437113@mail.megageek.com> <001e01cd02e9$82d057e0$887107a0$@rr.com> <4F626FBF.9040506@earthlink.net> |
On Thu, Mar 15, 2012 at 6:39 PM, Brian Kemp <bk13 at earthlink.net> wrote: > Then again, what about decimal time. In my job, I often have to make sense of time-based data that spans days or weeks. The way we do this is to assign each data point a number based on the day of the year, plus a fraction representing the elapsed part of the 24-hour day. Three decimal places is enough to represent minute-by-minute data, and pretty soon you learn to recognize that 62.25 is an early March day at 6:00 in the morning, while 185.875 is a good time to see some fireworks. I don't know if I want to live in that world all the time, though... Jeff Scarbrough Corrosion Acres, Ga. |
<Prev in Thread] | Current Thread | [Next in Thread> |
---|---|---|
|
Previous by Date: | [Shop-talk] OT- Excel help, (before I shoot my computer)!, Doug Braun |
---|---|
Next by Date: | [Shop-talk] metric time - was OT- Excel help, Rich White |
Previous by Thread: | [Shop-talk] metric time - was OT- Excel help, eric at megageek.com |
Next by Thread: | [Shop-talk] metric time - was OT- Excel help, Rich White |
Indexes: | [Date] [Thread] [Top] [All Lists] |