Timeclock Calculation

[john327]

I would like to set up a table in excel that allows me to enter, for example:
A time punched in (8:00 AM), time punched out (12:00 Noon) (for lunch) a time
punched back in (1:00 PM), a time punched out (5:00 PM).
I would like a final cell to calculate total work hours as 8 hours
worked for the day.

 

[Arvi Laanemets]

Hi

A1:E1 - "WorkdayStart", "LunchStart", "LunchEnd", "WorkdayEnd"
Format columns A as time (like Custom "hh:mm")
Into cell E2 enter the formula
=IF(OR(A2="";D2=""),"",(D2-A2)-(C2-B2))
or, in case workday stretches over midnight
=IF(OR(A2="",D2=""),"",(D2-A2+(D2<A2))-(C2-B2+(C2<B2)))
and copy it down

 

[Bill Kuunders]

enter in E2

=24*((D2-C2)+(B2-A2))


A2 = 08:00
B2= 12:00
C2= 01:00 p.m
D2= 05:00 p.m.

 

[Chip Pearson]

See www.cpearson.com/excel/overtime.htm for examples and a
downloadable workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com