extracting time from a cell
 

hi.

i work with vb6 and excel 2000 on win2k and i have the following problem
i need to extract data from an excel worksheet that holds a report from
a worker that fills the date and time his action took place, the format
is like this : one cell holds the date in the following format 22.11.2004
the second cell holds the hour in the following format 8:30
when i try to extract the time i get .354166666666667
how can i get the time in the correct format 8:30?
i can handle even if i get it with the seconds like 8:30:00

thanks in advance
gil eiliya

extracting time from a cell
 

An hour is 1/24 of a day.

--
Don Guillett
SalesAid Software

"gil eiliya" wrote in message
om...
hi.

i work with vb6 and excel 2000 on win2k and i have the following problem
i need to extract data from an excel worksheet that holds a report from
a worker that fills the date and time his action took place, the format
is like this : one cell holds the date in the following format 22.11.2004
the second cell holds the hour in the following format 8:30
when i try to extract the time i get .354166666666667
how can i get the time in the correct format 8:30?
i can handle even if i get it with the seconds like 8:30:00

thanks in advance
gil eiliya

extracting time from a cell
 

I think you did good.

Try formatting that cell (with .354166666666667) as: HH:MM (or HH:MM:SS)

gil eiliya wrote:

hi.

i work with vb6 and excel 2000 on win2k and i have the following problem
i need to extract data from an excel worksheet that holds a report from
a worker that fills the date and time his action took place, the format
is like this : one cell holds the date in the following format 22.11.2004
the second cell holds the hour in the following format 8:30
when i try to extract the time i get .354166666666667
how can i get the time in the correct format 8:30?
i can handle even if i get it with the seconds like 8:30:00

thanks in advance
gil eiliya

--

Dave Peterson