Added time + NOW within the working hours

[Treffend]

Is it possible to create a formula that the added time calculated within the working hours?


example: if there is on Friday added time, that he does not count weekends
stops friday 16u30 but continue from Monday 08u

A1 = the added time
A2 = the time now + the added time

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]50:00:00[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]=NOW()+(A1)[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]working hours[/TD]
[/TR]
[TR]
[TD="align: center"]mo - fr[/TD]
[TD="align: center"]08u - 16u30[/TD]
[/TR]
[TR]
[TD="align: center"]sa - su[/TD]
[TD="align: center"]closed[/TD]
[/TR]
</tbody>[/TABLE]

Thx in advance!

 

[Scott Huish]

What does u mean in your times?

 

[FDibbins]

NOW() will always update every time an entry or change is made to your sheet, it is a dynamic function, not static. Is that what you wanted?