How do I time Hours & mins in excel - Time sheet

[Guest]

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

 

[Anne Troy]

Try this, Helen:
http://www.officearticles.com/excel/adding_or_summing_time_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

 

[Paul Sheppard]

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

 

[swatsp0p]

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

 

[Guest]

Thank you

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

 

[Guest]

Thank you

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