SOLVED - Very Newbie troubles - Timesheet

[MaddiW]

Hi everyone
I'm new and only joined today! Hope I can find someone who can assist. I don't think my query is difficult but - Disclaimer: I'm terrible at Excel!!
Here is my problem -
The purpose of the spreadsheet is for a consultant to book time worked.
The billing cycle is not aligned with payroll.
Billing happens the 20th of month and payroll the end of month
Consultants do a forecast of hours for the period from billing to payroll
Consultants are paid based on total actual hours worked and forecasted hours inclusive
In the event that a consultant is sick or cannot work the hours as forecasted, the difference must be shown in order for payroll and billing to be adjusted in the next month.
The idea is that once timesheet is submitted for billing the consultant will capture actual time in same spreadsheet and the actual hours worked to be reconfirmed against the forecast

I really hope there is someone that can assist! Looking forward to learn something useful :-)

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)