I'm not sure what it means to format the cells differently, but I do have
different dates and all the times are different as well

"David Biddulph" wrote:

Does he need to format each cell differently?

What's wrong with
2008-01-01 01:26:22
2008-01-01 01:38:42
if that's what the OP prefers? (and remember that this would be the ISO8601
date format)

And =B1-A1 would give the duration.
--
David Biddulph

"Mike H" wrote in message
...
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!