View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kina
 
Posts: n/a
Default how do I calculate minutes when given two times?

I have a spreadsheet that contains one set of cells that is time in and
another set of cells that is time out.
I have been able to calculate elapsed time in hours and minutes by
converting the time in and time out to military time. Excel is reading this
as a time of day rather than the length of time.
How do I convert the elapsed time into minutes so that I can measure averages