| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Sheet for my org | Excel Discussion (Misc queries) | |||
| How do I move or copy more then one sheet at a time | Excel Worksheet Functions | |||
| Is there a time sheet template that calculates hours? | Excel Discussion (Misc queries) | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
| Time Sheet calculations | Excel Worksheet Functions | |||
Linear Mode
