Hi all

Is there a way(VBA or function/formula) to extract the time from a serial
date in excel?

i.e. date in cell is 38140.7291666667 (6/2/2004 5:30 pm)
and want to extract time only

Thanks in advance

DW

Function

=A1-INT(A1)

VBA

Now - Date

or

Range("A1") - Int(Range("A1"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dan W" <Dw6853_AT_msn_DOT_com wrote in message
...
Hi all

Is there a way(VBA or function/formula) to extract the time from a serial
date in excel?

i.e. date in cell is 38140.7291666667 (6/2/2004 5:30 pm)
and want to extract time only

Thanks in advance

DW

Thanks Bob
That did the trick


"Bob Phillips" wrote in message
...
Function

=A1-INT(A1)

VBA

Now - Date

or

Range("A1") - Int(Range("A1"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dan W" <Dw6853_AT_msn_DOT_com wrote in message
...
Hi all

Is there a way(VBA or function/formula) to extract the time from a
serial
date in excel?

i.e. date in cell is 38140.7291666667 (6/2/2004 5:30 pm)
and want to extract time only

Thanks in advance

DW

On Mon, 7 Jun 2004 12:39:17 -0600, "Dan W" <Dw6853_AT_msn_DOT_com wrote:

Hi all

Is there a way(VBA or function/formula) to extract the time from a serial
date in excel?

i.e. date in cell is 38140.7291666667 (6/2/2004 5:30 pm)
and want to extract time only

Thanks in advance

DW


With the value in A1, =MOD(A1,1) will extract the fractional part, which is
the time.


--ron

Thanks Ron

--

Dan W
(replace _DOT_ and _AT_ with normal email characters "@ . " if mailing
direct)


"Ron Rosenfeld" wrote in message
...
On Mon, 7 Jun 2004 12:39:17 -0600, "Dan W" <Dw6853_AT_msn_DOT_com wrote:

Hi all

Is there a way(VBA or function/formula) to extract the time from a serial
date in excel?

i.e. date in cell is 38140.7291666667 (6/2/2004 5:30 pm)
and want to extract time only

Thanks in advance

DW


With the value in A1, =MOD(A1,1) will extract the fractional part, which
is
the time.


--ron