Kristin has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course
Timesheet
I am trying to create a timesheet, whereby we input our arrival times, when we leave for lunch and come back as well as when we leave for the day. I want the sheet to calculate the total hours worked that day, the total hours worked for the week etc... I am having difficulty with this as you cannot have minus time. Could someone shed some light please. Thanks
RE: Timesheet
To simulate your requirement I created 5 columns
TimeInAM LunchOut LunchIn TimeOutPM DayTotal
08:30:00 AM 12:45:00 PM 01:30:00 PM 05:00:00 PM 07:45:00
Formatted the first 4 columns as TIME with AM/PM. The last column formatted as time without AM/PM
Then created the formula in the DayTotal column as follows:
(LunchOut - TimeInAM) + (TimeOutPM - LunchIn )
The Daytotal can then be summed as per your requirements.
You may want to add a few extra columns to track the date and persons name.
RE: Timesheet
Hi Richard,
Thanks for your response. Could you also help me as there are more calculations that I am having trouble with. I will try to explain as clearly as possible:
After the Total Hours for the Week are calculated I have to subtract it from the Standard Weekly Hours (expected). Sometimes this can be a negative, for example if someone has gone home early one day. How can I calculate negative time?
Thanks
Kristin
