Hi,

To format a cell with the cell selected

Format|Cells - select number tab - Custom

enter the formats in my previous post

Mike

"Kajuliano" wrote:

Thanks for all the relies but I am still having troulbe (I know very little
about excel). How do you format the column as dd:mm:yy?

"Mike H" wrote:

Hi,

All you actually need to do is format each cell differentll so

A1= 01/01/2008 01:26:22
b1= 01/01/2008 01:38:42

in C1 enter =a1 and format as dd:mm:yy and you get the date
in D1 enter = a1 and format as hh:mm:ss and you get a1 time
in E1 enter =b1 and format as hh:mm:ss and you get b1 time
in F1 ente = E1-D1 and you get the test duration

Mike


"Kajuliano" wrote:

Hi--

I'm new to excel and here is my issue:

I have two columns of data, the first column has both the date
(year-month-date) and time (in hours, minutes, and seconds-military) that a
participant started my questionnaire. The second column has the same exact
information (both date and time) but this tells me when the participant ended
the survey. This information lets me know how long it took an indiviudual to
complete the questionnaire and on what day they started it.

I need to:

1. split the date and time into two different columns (for both column 1 and
2- giving me 4 columns total, 2 with date, 2 with time)
2. calculate the time it took the participant to complete the survey
(subtract the end time from the start time)

I really have no idea where to begin, so any help would be appreciated-
thanks!