Hello everyone,
My first post here, I've searched the forums extensively for a past week but couldn't find exactly what I'm working on. Unfortunately my case has some weird details
.
I'd like to ask you for help as I'm stuck right now. Here's the table showing what I mean:
<tbody>
</tbody>
In short: I'd like to have possibility to prepare this separately for several different (fixed) working hours and also for different weekdays (some teams would work Sunday-Thursday in example instead of MON-FRI). Number of added hours would be user input.
Examples:
I open the the task which takes 8 hours on Friday 2/24/17 17:00
PS. The solution might be in VBA or Excel formula, doesn't really matter - I'm simply struggling with getting correct result.
Thank you very much, basically any help would be much appreciated!
Sam
My first post here, I've searched the forums extensively for a past week but couldn't find exactly what I'm working on. Unfortunately my case has some weird details
I'd like to ask you for help as I'm stuck right now. Here's the table showing what I mean:
start =now() | start shift | end shift | hours to add | expected result |
2-24-17 17:00 PM | 0:00 | 10:00 | 8 | 2-27-27 08:00 AM |
2-24-17 17:00 PM | 9:00 | 17:00 | 12 | 2-28-17 12:00 PM |
2-24-17 17:00 PM | 23:00 | 7:00 | 3 | 2-27-17 02:00 AM |
<tbody>
</tbody>
In short: I'd like to have possibility to prepare this separately for several different (fixed) working hours and also for different weekdays (some teams would work Sunday-Thursday in example instead of MON-FRI). Number of added hours would be user input.
Examples:
I open the the task which takes 8 hours on Friday 2/24/17 17:00
- I work MON-FRI 11:00 - 19:00 - the correct result would be 2/27/17 17:00 (weekend excluded - so Monday).
- I work MON-SAT 11:30 AM - 7:30 AM (through the midnight) - the result would be 2/25/17 1:00 AM.
PS. The solution might be in VBA or Excel formula, doesn't really matter - I'm simply struggling with getting correct result.
Thank you very much, basically any help would be much appreciated!
Sam