Jump to content

Timesheets


shadaca

Recommended Posts

Has anyone got a template for a timesheet?

 

All the ones I can find online aren't really workable for theatre.

 

What sort of thing are you after? Ours is an excel spreadsheet with columns for in-out-in-out each day. One day per row. The sheet calculates total hours each day, and if you enter a figure as 'normal working day' it keeps a running tally of whether you are 'up' or 'down' on your hours. It is a workbook of 13 sheets, each one a 4-week period making up a complete year. Running totals etc carry from one sheet to the next.

 

If thats any use I could send you a copy but it'll be later on when I'm back in the office.

 

Ben.

Link to comment
Share on other sites

My formula for timesheets is much the same as TMH's

 

=(D1-C1-(E1/1440)+(D1<C1))+(H1-G1-(I1/1440)+(H1<G1))

 

C1 = In time 1

D1 = Out time 1

E1 = Break time 1 (in minutes) - divide by 60 because we are working in minutes, then divide by 24 to convert to time format in excel - so divide by 1440

G1 = In time 2

H1 = Out time 2

I1 = Break time 2

 

I don't multiply by 24 - I just format row C,D,G,H and my total row as "Time"

 

and depending on the employee contract (ie permanent staff or casual), penalty if statements get tacked on the end too - and usually look like this:

 

=.....+IF((C2+1)-H1<6/24,2/24,0)

 

If our time in on day 2 is less than 6 hours (6/24) after our time out on day 1 add two hours penalty (2/24)

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.