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