Thread: [Solved] Processing Time Intervals
View Single Post
 
Old 09-29-2011, 12:33 PM
pkrishna pkrishna is offline Windows Vista Office 2007
Novice
 
Join Date: Jul 2011
Posts: 16
pkrishna is on a distinguished road
Default Processing Time Intervals

Why does Excel treat time as nothing but the time of the day, starting from year 1900?

If I have a pencil that is ten inches long, it is not as if one end of the pencil is so many miles, so many furlongs, so many yards, so many feet, and so many inches from the center of the earth, and the other end of the pencil is that much plus ten inches from the center of the earth.

I have great difficulty in getting Excel to consider values of time intervals, such as time to complete a task, response time after a stimulus is noticed, time taken to walk a mile, or complete formatting of a document. Why should all these intervals of time have to be tied up with time of the day concept? Sure, I have devised various ways of working around this limitation of Excel, but every time I do, I am surprised as the lack of a time duration variable.

Why didn't the programmers at Microsoft ever consider designating a simple time variable, divorced from a time-of-the-day variable?
Reply With Quote