|
This site needs Javascript to work, enable it by following the instructions here.
All files here are free, donations will go towards more files being created.
Click here to bookmark
Stumble It!
Save This Page
Contact
Phone: 0151 324 1191
Mobile: 07795 215 982
Email:
Spreadsheets Direct
*New Answer Service*:
Spreadsheet Solutions
Welcome to Spreadsheets Direct!
↑ Sign up to the RSS Feed for alerts when new files are added.
You may need to install the Analysis Toolpack/VBA, click Tools - Add-ins, tick them and then click OK
Enter Target Hours in B3 and then enter start and finish time for each day including lunch times. Column F will show how many hours have been worked in the day and column G will show how many hours are remaining. The second table will let you calculate your monthly hours. Enter the Target Monthly Hours in C14 and number of weeks in the month in C15. Add the daily hours for each weekday and columns H & I will show hours left to work or hours over.
