=--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.