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

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

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

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

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

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