What on earth??

[slippymississippi]

I entered the estimated length of my task as 4 days. This shows up in
the project server database as "19200"

Okay, so 19200 divided by 4 days is 4800. 4800 divided by 8 (hours /
day) is 600. 600 divided by 60 (minutes per hour) is 10.

10?

10 what?

Is it really necessary to track my time in 6 second increments?

 

[Charlie Holmes]

You answered your own question:

To get the number of days involved for a task:
X / 4800
(ex. 19200 / 4800 = 4)

To get the number of hours involved for a task:
X / 600
(ex. 19200 / 4800 * 8 = 19200 / 600 = 32)

Don't use this as a fixed reference though. Depending on which table
in the database you're querying, the formula used to calculate the
value of the database field is different.

Which table are you querying?

Thanks,
Charlie Holmes
RGA

 

[slippymississippi]

You answered your own question:

No I didn't! I want to know who came up with the idea of tracking my
time in 6 second increments, and why.

Which table are you querying?
dbo.MSP_TASKS

Depending on which table in the database you're querying, the
formula used to calculate the value of the database field is different.

Is there anything tricky about mining project information out of the
tasks table?

What about having a timesheet application that records time directly to
Microsoft Project Server tables?

 

[Mike Glen]

Hi slippymississippi,

Welcome to this Microsoft Project newsgroup

All versions of project use a base time 1/10 second - it was designed that
way.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

 

[slippymississippi]

All versions of project use a base time 1/10 second - it was designed that

way.

I assume you mean 1/10 minute, or six seconds. Why was it designed
that way? I have never seen any system where the atomic unit of time
was six seconds. My brane just can't comprehend that unit. Is this
like one of those olde english measurements, where the length of time
is based on the size of the king's foot or something?

 

[Mike Glen]

Sorry, yes 1/10 min! As far as I know, Project is an all American product.
I don't know of any english measurement that was based on 1/10 min. Only
the original designer can answer your question. Unless someone else knows?


Mike Glen
Project MVP

 

[Charlie Holmes]

It's the amount of time that it takes a developer to come up with a
completely random measurement.

Charlie Holmes
RGA

 

[Mike Glen]

Ha


Mike Glen
Project MVP