Formula for time cards

[Guest]

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

 

[Guest]

hi,

Have a look here. Examples and downloads

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

Mike

 

[T. Valko]

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(C22)=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.

 

[Gord Dibben]

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