Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically plotting hours used
Please help - really really desperate. How do I automatically take the hours
used in a jobcard and make them appear in a time & date schedule in sheet 2. Is there anybody who has a template for this? Really tired of looking, cant find anything and I am not good with excel. Many thanks Hilda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically plotting hours used
Hilda;
don't get frustrated for this, I did back in 2000 and found a solution. Are you trying to calculate the time cards of hourly employees? I know the solution is not as easy as it may appears. Argy! "Hilda" wrote: Please help - really really desperate. How do I automatically take the hours used in a jobcard and make them appear in a time & date schedule in sheet 2. Is there anybody who has a template for this? Really tired of looking, cant find anything and I am not good with excel. Many thanks Hilda |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically plotting hours used
Hi Argy, sorry brand new to the site and keep bungling things up. No not for
time cards of employees. My business is doing embroidery work and I have manged to work out a jobcard that calculates the time needed per job. Now I need to plot the time needed into a daily calender so that I can see that the time needed for a specific job has been booked. Many times we have customers who want a job done and I end up thumb sucking (which gets me into a lot of trouble) and I end up double booking. I thought that by doing this in excel I would be more professionally organized and would get into less trouble. I need to carry the hours need into a date (like in a diary) and book the hours by colouring them in. Please I dont know if I am making any sence. But any help will be appreciated. Thanks Hilda "Argy - Arcasoft" wrote: Hilda; don't get frustrated for this, I did back in 2000 and found a solution. Are you trying to calculate the time cards of hourly employees? I know the solution is not as easy as it may appears. Argy! "Hilda" wrote: Please help - really really desperate. How do I automatically take the hours used in a jobcard and make them appear in a time & date schedule in sheet 2. Is there anybody who has a template for this? Really tired of looking, cant find anything and I am not good with excel. Many thanks Hilda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically plotting all points for a specific time period | Excel Worksheet Functions | |||
automatically update hours | Excel Worksheet Functions | |||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
automatically update chart plotting current month and previous 6 | Charts and Charting in Excel | |||
How can empty cells automatically highlight after 24 hours? | Excel Worksheet Functions |