shadaca Posted December 8, 2008 Share Posted December 8, 2008 Has anyone got a template for a timesheet? All the ones I can find online aren't really workable for theatre. Link to comment Share on other sites More sharing options...
Biskit Posted December 8, 2008 Share Posted December 8, 2008 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 More sharing options...
themadhippy Posted December 8, 2008 Share Posted December 8, 2008 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))*24were A is the start time and B is the finish time,seems to work fine Link to comment Share on other sites More sharing options...
mac.calder Posted December 8, 2008 Share Posted December 8, 2008 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 1D1 = Out time 1E1 = 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 1440G1 = In time 2H1 = Out time 2I1 = 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.