| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to count the time?
Assume that you have beginning of lunch (12:30 PM) in cell A2, and end of
lunch (2:30 PM) in cell A3. Also, time duration in cell C6 is written as time (60 minutes is inputted as 1:00 or 0:60). Formula is: =IF(C3-C6<A3,A2-(C3-A3),C3-C6) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Eric" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
