Typing times

[Dean]

Hi

Is there a way to type times easily in Excel ?

It is used for keeping track of times during production.

Input would be;

Startup 6.30 6.45
Production order No 1 6.45 8.30
Change of product 8.30 8.50
Production order No 2 8.50 12.15
Maintenance 12.15 13.00
Lunch 13.00 13.45
etc

Data has to be summerized on the different lines (start
up, production, maintenance, lunch etc)

The problem is the time it takes to punch it in.

Kind regards,
Dean

 

[Paul B]

Dean, have a look here

http://www.cpearson.com/excel/DateTimeEntry.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **