if you format a column date and time, then enter, say 01/06/08 10:30 AM, then
do the VALUE of that cell, you will get a decimal number that represents the
date and time. That could be your reference number.

"Steve C" wrote:

I am trying to create a spreadsheet to log some drawings that are done. I
would also like to use the julian date as a reference number. I have tried to
use the function found here, http://www.cpearson.com/excel/jdates.htm, but
that doesn't give me enough detail. Since I need multiple reference numbers
during the day, that function, which only gives me the year and the day,
limits my numbering scheme.

Can anyone help?

Thanks in advance!

I tried that, and ended up only getting the year and day format, no
hours/minutes, etc. Do you know if there is something missing from the
original function that was listed on the website? I'm not sure if using that
will allow the return to be anything more than just the year and day.

Thanks for your reply!

"dlw" wrote:

if you format a column date and time, then enter, say 01/06/08 10:30 AM, then
do the VALUE of that cell, you will get a decimal number that represents the
date and time. That could be your reference number.

"Steve C" wrote:

I am trying to create a spreadsheet to log some drawings that are done. I
would also like to use the julian date as a reference number. I have tried to
use the function found here, http://www.cpearson.com/excel/jdates.htm, but
that doesn't give me enough detail. Since I need multiple reference numbers
during the day, that function, which only gives me the year and the day,
limits my numbering scheme.

Can anyone help?

Thanks in advance!

Hi Steve

You could modify Chip's formula to
=RIGHT(YEAR(A1),2)&TEXT(A1-DATE(YEAR(A1),1,0),"000")&TEXT(MOD(A1,1)*1440,"000 0")

You will get the Julian date with a number following it that will range from
0000 to 1440 representing each minute of the day.

--

Regards
Roger Govier

"Steve C" wrote in message
...
I tried that, and ended up only getting the year and day format, no
hours/minutes, etc. Do you know if there is something missing from the
original function that was listed on the website? I'm not sure if using
that
will allow the return to be anything more than just the year and day.

Thanks for your reply!

"dlw" wrote:

if you format a column date and time, then enter, say 01/06/08 10:30 AM,
then
do the VALUE of that cell, you will get a decimal number that represents
the
date and time. That could be your reference number.

"Steve C" wrote:

I am trying to create a spreadsheet to log some drawings that are done.
I
would also like to use the julian date as a reference number. I have
tried to
use the function found here, http://www.cpearson.com/excel/jdates.htm,
but
that doesn't give me enough detail. Since I need multiple reference
numbers
during the day, that function, which only gives me the year and the
day,
limits my numbering scheme.

Can anyone help?

Thanks in advance!

Excellent, just the return I was looking for!

Many thanks!




"Roger Govier" wrote:

Hi Steve

You could modify Chip's formula to
=RIGHT(YEAR(A1),2)&TEXT(A1-DATE(YEAR(A1),1,0),"000")&TEXT(MOD(A1,1)*1440,"000 0")

You will get the Julian date with a number following it that will range from
0000 to 1440 representing each minute of the day.

--

Regards
Roger Govier

"Steve C" wrote in message
...
I tried that, and ended up only getting the year and day format, no
hours/minutes, etc. Do you know if there is something missing from the
original function that was listed on the website? I'm not sure if using
that
will allow the return to be anything more than just the year and day.

Thanks for your reply!

"dlw" wrote:

if you format a column date and time, then enter, say 01/06/08 10:30 AM,
then
do the VALUE of that cell, you will get a decimal number that represents
the
date and time. That could be your reference number.

"Steve C" wrote:

I am trying to create a spreadsheet to log some drawings that are done.
I
would also like to use the julian date as a reference number. I have
tried to
use the function found here, http://www.cpearson.com/excel/jdates.htm,
but
that doesn't give me enough detail. Since I need multiple reference
numbers
during the day, that function, which only gives me the year and the
day,
limits my numbering scheme.

Can anyone help?

Thanks in advance!