View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Kuhn David Kuhn is offline
external usenet poster
 
Posts: 1
Default Calculating the minutes between two times

Hello all,

A time card application:
If I enter a start time in a cell and a ending time in another cell,
how to I calculate the minutes in-between?

For example, a cell contains 6:00 AM and another cell contains
2:30PM. I know that is 8 hours worked (with half hour lunch). How
can I have Excel calculate 8.5 hours or 510 minutes?

Thanks kindly.

Dave Kuhn