I am trying to make a template for time card:

Date Day In Out Hours worked Accumulated
Hours

EX: 12 Mo 9:02 3:02 5:30 5:30
13 Tu 9:00 3:08 5:38 11:08

Need formulas for above that minus a 1/2 lunch break?

I don't see any templates with accumulated hours.
Thanks
Susie

hi,

Have a look here. Examples and downloads

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

Mike

"Susieq" wrote:

I am trying to make a template for time card:

Date Day In Out Hours worked Accumulated
Hours

EX: 12 Mo 9:02 3:02 5:30 5:30
13 Tu 9:00 3:08 5:38 11:08

Need formulas for above that minus a 1/2 lunch break?

I don't see any templates with accumulated hours.
Thanks
Susie

When you enter your In/Out times you should include the AM/PM (or use a 24
hour clock)

For hours worked (I'm assuming they will have worked at least 30 mins):

=IF(COUNT(C2:D2)=2,D2-C2+(D2<C2)-30/1440,"")

For the accumulated time:

=IF(E2="","",SUM(F1,E2))

Note: in this formula F1 is the column header "Accumulated".

Format both as [h]:mm

Copy both formulas down as needed.

--
Biff
Microsoft Excel MVP


"Susieq" wrote in message
...
I am trying to make a template for time card:

Date Day In Out Hours worked Accumulated
Hours

EX: 12 Mo 9:02 3:02 5:30 5:30
13 Tu 9:00 3:08 5:38 11:08

Need formulas for above that minus a 1/2 lunch break?

I don't see any templates with accumulated hours.
Thanks
Susie

See Chip Pearson's site for an example timesheet with lunch breaks and OT
calculations.

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


Gord Dibben MS Excel MVP

On Mon, 30 Jul 2007 11:22:01 -0700, Susieq
wrote:

I am trying to make a template for time card:

Date Day In Out Hours worked Accumulated
Hours

EX: 12 Mo 9:02 3:02 5:30 5:30
13 Tu 9:00 3:08 5:38 11:08

Need formulas for above that minus a 1/2 lunch break?

I don't see any templates with accumulated hours.
Thanks
Susie