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.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread:https://www.excelforum.com/excel-formulas-and-functions/1330548-very-newbie-troubles-timesheet.html#post5412483