| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I export hours from one sheet into a time & date schedule
I would like to automatically make the hours, date and jobcard no from my
jobcard in sheet 1 appear in sheet 2 as "time used" this should also be colour in. I would like the time used to be in a calender dairy so that I can see how many hours of the day has already been allocated to a specific job and how many hours are still available for other jobs. This is also to prevent double booking of jobs. The hours in the dairy must be for a 24 hr clock. Please anybody, I am desperate. I do not know anything about programming. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for hours on time sheet | Excel Discussion (Misc queries) | |||
| Hours between date/Time | Excel Worksheet Functions | |||
| Need wkly schedule template, show time in & out, & total hours | Excel Discussion (Misc queries) | |||
| How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) | |||
| time-sheet record with over 24 hours | New Users to Excel | |||
Linear Mode
