Please enable JavaScript.
Coggle requires JavaScript to display documents.
Do not disturb btn - Coggle Diagram
Do not disturb btn
Sharepoint list
choice
30 min
60 min
120 min
date time
Now
Calculated field ?
Formulas / functions
Today() and Now()
https://answers.microsoft.com/en-us/msoffice/forum/all/sharepoint-list-adding-a-duration-column/dd3157f7-7130-429e-ae0c-7d66aaeb016f
https://www.premierpointsolutions.com/training/help-and-how-to-articles/how-to-add-and-subtract-hours-and-minutes-from-date-and-time-fields-in-sharepoint-lists/
Calculated field
Countdown
current time
DoNotDisturb
2022-06-0 7 09:35
DoNotDisturb+1
2022-06-0 (8) 09:35
Timer
(1/24/60*Timer)
Days/hours/min
timer field
30 / 60 / 120 min
=(DoNotDisturb+(1/24/60*Timer))
Today()
=TEXT(DoNotDisturb-(DoNotDisturb+(1/24/60*Timer));"h:mm")
DoNotDisturb when created
=TEXT(IDAG()-(DoNotDisturb+(1/24/60*Timer));"h:mm")
=HELTAL((((DoNotDisturb+(1/24/60
Timer)-(NU()+9/24)))
1440))
(Now()+9/24)
Control
Drop down
Patch
IF
btn 60 min choicen
Remove time value after 60 min
btn 30 min choicen
Remove time value after 30 min
LookUp
User