Excel Sum formula for timesheets.

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.

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 Noob

Check out Chip Pearson's site for timesheet formulas.

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


Gord Dibben MS Excel MVP

On Fri, 28 Jul 2006 13:38:02 -0700, HR problem with using formulas. <HR problem
with using formulas.@discussions.microsoft.com> wrote:

>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.

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


"HR problem with using formulas." wrote:

> 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.