Subtracting Times

[tvhazlett]

How can I subtract times (13:00-07:00)-(half hour lunch) and get a decimal
answer (5.5)? I would like to be able to just type a "7", for example, and
have it automatically displayed in the cell as "07:00 AM". I'm trying to set
up a company timesheet and I'd like to be able to enter information with as
few keystrokes as possible. I would appreciate any help with this. Thanks
in advance!

 

[Frank Kabel]

Hi
for subtracting try:
=(B1-A1-(0.5/24))*24
and format as number

For quick entries you need VBA. See:
http://www.cpearson.com/excel/DateTimeEntry.htm