## Recommended Posts

Has anyone got a template for a timesheet?

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

##### Share on other sites

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.

##### Share on other sites

We use the same as above,the hardest bit is getting it to accept times past midnight as the same day.however

` (B1-A1+(B1<A1))*24`

were A is the start time and B is the finish time,seems to work fine

##### 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)