I am using a google document survey to have users enter times in a military
format. The result is pasted into excel as a "General" format number, like
2253 to represent 10:53PM. They do not enter the semicolon between hours and
minutes.

I need to see the number of minutes between two times, such as 2257 - 2253
or 4 minutes.

How can I convert general numbers, some of which are 04 to represent 00:04
AM, to serial times or time format?

Thanks very much in advance.

Suppose
A1 = 2257 (formated as text)
B1 = 2253 (formated as text)

Try the below formula in C1 (formatted as hh:mm)

=TIME(INT(LEFT(A1,2)-LEFT(B1,2)),INT(RIGHT(A1,2)-RIGHT(B1,2)),0)

If this post helps click Yes
---------------
Jacob Skaria


"MGranger" wrote:

I am using a google document survey to have users enter times in a military
format. The result is pasted into excel as a "General" format number, like
2253 to represent 10:53PM. They do not enter the semicolon between hours and
minutes.

I need to see the number of minutes between two times, such as 2257 - 2253
or 4 minutes.

How can I convert general numbers, some of which are 04 to represent 00:04
AM, to serial times or time format?

Thanks very much in advance.

=TIME(LEFT(A9,2),MID(A9,3,2),0)

"MGranger" wrote:

I am using a google document survey to have users enter times in a military
format. The result is pasted into excel as a "General" format number, like
2253 to represent 10:53PM. They do not enter the semicolon between hours and
minutes.

I need to see the number of minutes between two times, such as 2257 - 2253
or 4 minutes.

How can I convert general numbers, some of which are 04 to represent 00:04
AM, to serial times or time format?

Thanks very much in advance.

=--TEXT(A2,"00\:00") and format as time.
--
David Biddulph

MGranger wrote:
I am using a google document survey to have users enter times in a
military format. The result is pasted into excel as a "General"
format number, like 2253 to represent 10:53PM. They do not enter the
semicolon between hours and minutes.

I need to see the number of minutes between two times, such as 2257 -
2253 or 4 minutes.

How can I convert general numbers, some of which are 04 to represent
00:04 AM, to serial times or time format?

Thanks very much in advance.

On Mon, 25 May 2009 04:25:01 -0700, MGranger
wrote:

I am using a google document survey to have users enter times in a military
format. The result is pasted into excel as a "General" format number, like
2253 to represent 10:53PM. They do not enter the semicolon between hours and
minutes.

I need to see the number of minutes between two times, such as 2257 - 2253
or 4 minutes.

How can I convert general numbers, some of which are 04 to represent 00:04
AM, to serial times or time format?

Thanks very much in advance.

And a numeric solution:

=(INT(A1/100)+MOD(A1,100)/60-
(INT(B1/100)+MOD(B1,100)/60))*60

And another method, if you have either Excel 2007+ or have installed the
Analysis Tool Pak:

=(DOLLARDE(A1/100,60)-DOLLARDE(B1/100,60))*60

--ron

I am using a google document survey to have users enter times in a
military
format. The result is pasted into excel as a "General" format number,
like
2253 to represent 10:53PM. They do not enter the semicolon between hours
and minutes.

I need to see the number of minutes between two times, such as 2257 -
2253
or 4 minutes.

How can I convert general numbers, some of which are 04 to represent
00:04
AM, to serial times or time format?

Thanks very much in advance.

And a numeric solution:

=(INT(A1/100)+MOD(A1,100)/60-
(INT(B1/100)+MOD(B1,100)/60))*60

And another method, if you have either Excel 2007+ or have installed the
Analysis Tool Pak:

=(DOLLARDE(A1/100,60)-DOLLARDE(B1/100,60))*60

Another method (making use of the formula David posted)...

=1440*(TEXT(A1,"00\:00")-TEXT(B1,"00\:00"))

--
Rick (MVP - Excel)