Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the time?
Does anyone have any suggestions on how to count the time?
Lunch break is between 12:30 pm and 2:30 pm Example 1 I would like to manage and know when I should start working on the task, if I need 1 hour to finish A project, and the deadline is 3pm, therefore I should start work on it at 12pm, 12:00 - 12:30 and 2:30 - 3:00 = 1 hour Finish time is given at cell C3, which is 3 pm and the required time is given in cell C6, which is 60 minutes The starting time sould be returned in cell C2, which should be 12 pm Example 2 I would like to manage and know when I should start working on the task, if I need 30 minutes to finish A project, and the deadline is 2:45pm, therefore I should start work on it at 12:15pm, 12:15 - 12:30 and 2:30 - 2:45 = 30 mins Finish time is given at cell C3, which is 2:45 pm and the required time is given in cell C6, which is 30 minutes The starting time sould be returned in cell C2, which should be 12:15 pm Does anyone have any suggestions on how to do it in Excel? Thanks in advance for any suggestions Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
how to count the time | Excel Discussion (Misc queries) | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions |