ADDHOURS Function: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 6: | Line 6: | ||
}} | }} | ||
'''ADDHOURS()''' — function adds or subtracts a specified number of hours from the selected date. | '''ADDHOURS()''' — function adds or subtracts a specified number of hours from the selected date. | ||
== Format == | == Format == | ||
'''ADDHOURS'''(Date | '''ADDHOURS'''(Date; Count) | ||
== Examples == | == Examples == | ||
Subtract -3 hours from today's date (24-06-2022 10:10): | Subtract -3 hours from today's date (24-06-2022 10:10): | ||
'''ADDHOURS'''(Now();-3) — Result: 24-06-2022 07:10 | '''ADDHOURS'''(Now();-3) — Result: 24-06-2022 07:10 | ||
Add +4 hours to today's date (24-06-2022 10:15): | Add +4 hours to today's date (24-06-2022 10:15): | ||
'''ADDHOURS'''(Now();4) — Result: 24-06-2022 14:15 | '''ADDHOURS'''(Now();4) — Result: 24-06-2022 14:15 | ||
Latest revision as of 14:13, 9 January 2025
ADDHOURS() — function adds or subtracts a specified number of hours from the selected date.
Format
ADDHOURS(Date; Count)
Examples
Subtract -3 hours from today's date (24-06-2022 10:10):
ADDHOURS(Now();-3) — Result: 24-06-2022 07:10
Add +4 hours to today's date (24-06-2022 10:15):
ADDHOURS(Now();4) — Result: 24-06-2022 14:15