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!

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

--
Regards
Frank Kabel
Frankfurt, Germany

"tvhazlett" schrieb im
Newsbeitrag ...
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!