Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
extracting time from a cell
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting time (hr:min) from date/time format | Excel Discussion (Misc queries) | |||
Extracting date from Date and Time formatted cell | Excel Discussion (Misc queries) | |||
extracting time only | Excel Worksheet Functions | |||
Extracting Time from a cell that has both the date and the time | Excel Discussion (Misc queries) | |||
Extracting time | Excel Discussion (Misc queries) |