| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thank you
"Paul Sheppard" wrote: Helen Wrote: I wish to set up a time sheet to record the number of hours worked in a day. How do I get excel to add time. ie Hours worked 8:30 - 13:00, 14:00 - 17:30 = 8 hour day. I am using Office 2000 Hi Helen You will need 5 columns eg A - E Column A = Time In Column B = Time Out Column C = Time In Column D = Time Out Column E = Time Worked A2 08:30 B2 13:00 C2 14:00 D2 17:30 E2 =SUM((B2-A2)+(D2-C2)) Format cells as Custom hh:mm -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=467523 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Is there a time sheet template that calculates hours? | Excel Discussion (Misc queries) | |||
| make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Hybrid Mode
