View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MGranger MGranger is offline
external usenet poster
 
Posts: 1
Default Calculating Difference Between Two Times in General Format

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.