help making an excel spreadsheet

[HarryKeogh]

i'm trying to make a simple spreadsheet where in one cell i can type in the time an employee starts, in another cell the time they finish and have the hours worked pop up in a third cell (automatically deducting one half hour for lunch break)

example. cell 1a, i type in 6:50
cell 2a, i type in 3:20
and voila in cell 3a it will read: 8.00 hours

if anybody can help i'd really appreciate it!!!

[roger]

example:
put 6:50 in A1
put 15:20 (or 3:20 pm) in B1
put =B1-A1-TIME(0,30,0) in C1

C1 will display the hours.

You will probably have to adjust the formats of the cell so the times show up correctly. If you follow the example above, C1 will probably display 1/1/1970 8:10 or something.Select the entire column or row, Format...Cells.., select time, and then the formatting that you want for the time.

edited because I figured out something obvious.

edited to point out that you can also use "0:30" (with the quotations) in the equation instead of the TIME function.

[roger]

And, this help topic from excel is useful for knowing how to input time:

Quote:

The 12-hour or 24-hour clock To type a time based on the 12-hour clock, type a space followed by AM or PM (or A or P) after the time. Otherwise, Excel bases the time on the 24-hour clock. For example, if you type 3:00 instead of 3:00 PM, the time is stored as 3:00 AM

[HarryKeogh]

thanks Roger

[roger]

[john wayne]anytime, pilgrim[/john wayne]