G
Guest
I use excel to record my timesheets for work.
I write in the time i arrive, the time i leave and the time spent on my
lunch break.
I use basic formulas to calculate the hours for each day and the total for
the week, which is a maximum of 36 hours.
DAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY
START 8:30 8:30 8:15 8:00 8:00
FINISH 17:00 17:00 16:00 16:30 14:30
LUNCH 0:45 0:45 0:45 0:45 0:45
TOTAL 7:45 7:45 7:00 7:45 5:45
GRAND TOTAL 7:45:00 15:30:00 22:30:00 30:15:00 36:00:00
I want to use the solver to allow me to see what time i could finish later
in the week by solving the timesheet to reach my target hours of 36.
When i try to use a solver it says it cannot get an answer.
Any help would be much appreciated
Jody Williams
I write in the time i arrive, the time i leave and the time spent on my
lunch break.
I use basic formulas to calculate the hours for each day and the total for
the week, which is a maximum of 36 hours.
DAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY
START 8:30 8:30 8:15 8:00 8:00
FINISH 17:00 17:00 16:00 16:30 14:30
LUNCH 0:45 0:45 0:45 0:45 0:45
TOTAL 7:45 7:45 7:00 7:45 5:45
GRAND TOTAL 7:45:00 15:30:00 22:30:00 30:15:00 36:00:00
I want to use the solver to allow me to see what time i could finish later
in the week by solving the timesheet to reach my target hours of 36.
When i try to use a solver it says it cannot get an answer.
Any help would be much appreciated
Jody Williams