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

H

Helen

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
 
P

Paul Sheppard

Helen said:
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
Click to expand...

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
 
S

swatsp0p

Paul said:
Hi Helen
..............
E2 =SUM((B2-A2)+(D2-C2))

Format cells as Custom hh:mm
Click to expand...

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
 
H

Helen

Thank you

Paul Sheppard said:
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
Click to expand...
 
H

Helen

Thank you

swatsp0p said:
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
Click to expand...
 
Top