Time between two points in time

[David]

I have a list of time points in the following format:
12/11/2003 15:22
11/11/2003 03:02
11/11/2003 18:22
11/11/2003 23:02
11/11/2003 23:58
in column A, how do I find the number of minutes between
each time point and put it in column B. I've tried
TIMEVALUE (eg B1=TIMEVALUE(A1)) and it does not seam to
recognise this.

 

[Jason Morin]

One way:

=TEXT(A2-A1,"[m]")*1

Put this in B2 and fill down.

HTH
Jason
Atlanta, GA

 

[Guest]

Sorry this does not seam to work I think part of the
problem is the dates are in english format ie day of the
month followed buy month, and excel does not seam to
recognise these as dates and you just get an erroe
result, any more thoughts?

-----Original Message-----
One way:

=TEXT(A2-A1,"[m]")*1

Put this in B2 and fill down.

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a list of time points in the following format:
12/11/2003 15:22
11/11/2003 03:02
11/11/2003 18:22
11/11/2003 23:02
11/11/2003 23:58
in column A, how do I find the number of minutes between
each time point and put it in column B. I've tried
TIMEVALUE (eg B1=TIMEVALUE(A1)) and it does not seam to
recognise this.

.

.

 

[Jason Morin]

Check your Regional Settings under your Control Panel and
make sure your PC is set to read UK date format. Then
close Excel and re-open the file. This formula should work
fine.

The other issue is these cells may be text, so convert
them to actual date/time by multiplying all of them by 1.

Jason

-----Original Message-----
Sorry this does not seam to work I think part of the
problem is the dates are in english format ie day of the
month followed buy month, and excel does not seam to
recognise these as dates and you just get an erroe
result, any more thoughts?

-----Original Message-----
One way:

=TEXT(A2-A1,"[m]")*1

Put this in B2 and fill down.

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a list of time points in the following format:
12/11/2003 15:22
11/11/2003 03:02
11/11/2003 18:22
11/11/2003 23:02
11/11/2003 23:58
in column A, how do I find the number of minutes between
each time point and put it in column B. I've tried
TIMEVALUE (eg B1=TIMEVALUE(A1)) and it does not seam to
recognise this.

.

.

.