ADDHOURS Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=ADDHOUR Function |titlemode=append |keywords=planfix, reports, functions |description=ADDHOUR Function }} '''ADDHOUR()''' — function adds or subtracts a specified number of hours from the selected date. == Format == '''ADDHOUR'''(Date, Count) == Examples == Subtract -3 hours from today's date (24-06-2022 10:10): '''ADDHOUR'''(Now();-3) — Result: 24-06-2022 07:10 Add +4 hours to today's date (24-06-2022 10:15): '''ADDHOUR'''(Now();4) — Result: 2...") |
No edit summary |
||
| Line 3: | Line 3: | ||
|titlemode=append | |titlemode=append | ||
|keywords=planfix, reports, functions | |keywords=planfix, reports, functions | ||
|description= | |description=ADDHOURS Function | ||
}} | }} | ||
''' | '''ADDHOURS()''' — function adds or subtracts a specified number of hours from the selected date. | ||
== Format == | == Format == | ||
''' | '''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 | ||
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 | ||
Revision as of 17:45, 18 September 2024
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