If you have time in this format hh:mm you can convert it to minutes by
multiplying with 1440 and format it as General (don't forget to change the
format)
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
"Kina" wrote in message
...
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