Excel Sum formula for timesheets.

[Guest]

I work in a very small office and manual fill in time sheets on a weekly
bases but I can't figure out the simple formula to add clock in, lunch out,
lunch in and clock out on a daily bases per employee.

 

[VBA Noob]

This formula should work

=(E12<D12)+E12-D12+(G12<F12)+G12-F12

D12 = Start Work
E12 = Time Out (Lunch)
F12 = Time In (Lunch)
G12 = End Work


H12 has formula and is formatted as [h]:mm



Try the attached link for more help on subject

http://www.cpearson.com/excel/datetime.htm


http://www.j-walk.com/ss/excel/files/timesht.htm

VBA Noo

 

[Guest]

To get time interval between two times simple take one time from another

So "Lunch out" - "Clock in" is time prior to lunch (?)

and

"Lunch in" - "Clock out" is time after lunch

so if A1=Clock in and B1=Lunch out, then E1 (for example) =B1-A1

Format cells as hh:mm or if time period is more than 24 hours, use [h]:mm in
the cells containing the calculation formulae

HTH

 

[Gord Dibben]

Check out Chip Pearson's site for timesheet formulas.

http://www.cpearson.com/excel/overtime.htm


Gord Dibben MS Excel MVP