[SOLVED] Time Sheet - How Do I?

I need to create a timesheet for myself to add up the hours I work

How do I set it up so the time is calculated itself rather than my having to
work it out.

I will have the following headings:-

Date
Time Started (ie 9.00am)
Break (ie lunch if taken)
Time Finished (ie 4.00pm)

In essence 09.00am - 16.00pm = 7 hours (less 1 hour for lunch)

Thanks

A B
1 Started 10:00
2 To lunch 12:00
3 From lunch 13:00
4 Home 16:00
5 Total 05:00
B5 =(b2-b1)+(b4-b3)

Regards.

Bill Ridgeway
Computer Solutions

"DLee" <[email protected]> wrote in message
news:[email protected]...
>I need to create a timesheet for myself to add up the hours I work
>
> How do I set it up so the time is calculated itself rather than my having
> to
> work it out.
>
> I will have the following headings:-
>
> Date
> Time Started (ie 9.00am)
> Break (ie lunch if taken)
> Time Finished (ie 4.00pm)
>
> In essence 09.00am - 16.00pm = 7 hours (less 1 hour for lunch)
>
> Thanks
>