Thank you I will try the website.

"Kevin B" wrote:

This site has great information on a variety of Excel topics, this page link
is to the Dates & Times page, covering an array of date and time arithmetic
functions.

http://www.cpearson.com/excel/datetime.htm
--
Kevin Backmann


"Tracy" wrote:

I am trying to create a spreadsheet that will calculate time cards less a
lunch period. I cannot seem to get it to calculate the reduction of the
lunch period properly. Columns A,B & C would be input. Can anyone help?


Column A Column B Column C Column D
Start time End time Lunch Total Hours

7:32 4:00 :30 ?
7:30 4:15 :30 ?
7:35 4:30 :35 ?
8:00 4:30 0 ?
7:30 4:02 :30 ?

Total Hours ?