Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I time Hours & mins in excel - Time sheet
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 |
#2
|
|||
|
|||
Try this, Helen:
http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Helen" wrote in message ... 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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Paul Sheppard Wrote: Hi Helen .............. E2 =SUM((B2-A2)+(D2-C2)) Format cells as Custom hh:mm Paul's formula will sort of return the number of hours worked. However, in the hh:mm format, it is actually shown as a time, such as 08:00 a.m.. It is difficult to do further calculations (e.g. pay calcs). You could format E2 as General and use this formula to return the actual number of hours worked: E2 =((B2-A2)+(D2-C2))*24 {the SUM function is not needed} HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=467523 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
Thank you
"swatsp0p" wrote: Paul Sheppard Wrote: Hi Helen .............. E2 =SUM((B2-A2)+(D2-C2)) Format cells as Custom hh:mm Paul's formula will sort of return the number of hours worked. However, in the hh:mm format, it is actually shown as a time, such as 08:00 a.m.. It is difficult to do further calculations (e.g. pay calcs). You could format E2 as General and use this formula to return the actual number of hours worked: E2 =((B2-A2)+(D2-C2))*24 {the SUM function is not needed} HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 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 |