| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to Paul Lautman - timesheet
I wish to do the following:
Pat wrote: How can I, just by inserting work period eg 8 16, afterwards in 2 cells see all hours between 18 and 22 and hours between 22 and 5:15? Eg as written he working time evening hours night hours Patricia 12 20 2 0 Maria 16 24 4 2 -Where I only have to write the working time and excel calculates the rest... I'm really having difficulties. Thanks! Where 13,5 is 1:30 pm 16,25 is 4:14 pm etc... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to Paul Lautman - timesheet
Pat wrote:
I wish to do the following: Pat wrote: How can I, just by inserting work period eg 8 16, afterwards in 2 cells see all hours between 18 and 22 and hours between 22 and 5:15? Eg as written he working time evening hours night hours Patricia 12 20 2 0 Maria 16 24 4 2 -Where I only have to write the working time and excel calculates the rest... I'm really having difficulties. Thanks! Where 13,5 is 1:30 pm 16,25 is 4:14 pm etc... I have answered your original thread with a formula that will work if you enter the times as times. You should be able to change it to accommodate your format of data entry. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| displaying selected items from a yearplanner in a timesheet | Excel Discussion (Misc queries) | |||
| How do I calculate an employee timesheet in Excel? | Excel Worksheet Functions | |||
| Timesheet help | Excel Worksheet Functions | |||
| overtime on timesheet | Excel Worksheet Functions | |||
| timesheet with running total of overtime | Excel Worksheet Functions | |||
Linear Mode
