ADDHOURS Function

From Planfix
Revision as of 10:23, 28 February 2024 by Dmitri (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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: 24-06-2022 14:15


Go To