date and hours issue
 

Hi at all,
i've got this question for excle expert :-)

i've got this kind of cells (about 3000-4000):

start time cell : 2005-04-13 19:43:22.0
end time cell :2005-05-14 22:23:01.0 (i cannot divide the cell in date -
time because someone have formatted them in this way)

I need to separate the time (in minute) in those way (putting the minute in
other cells):
from 08 to 18 (working day) in one cell
from 18 to 08 (working day) in another cell
from friday at 18.00 to monday at 8.00 in another cell
all transformed in minute....
Thanks a lot guy

If a cell is formatted in a particular way then you should be able to
change it to suit your needs or application. Or did you mean to say
that the entry in the cell is "2005-05-14 22:23:01.0" instead of a
serial date number?

The answer will determine how you resolve the problem. To find out,
click on any date cell and attempt to change its format to a number
with no decimals or commas. If you get a 5 digit number then you can
format this value- in Excel parlance this is called a serial date
number- to show whatever you like.

If the cell still shows 2005-05-14 22:23:01.0 then the solution is a
touch more difficult but not unworkable.

Let us know!