ADDHOURS Function

From Planfix
Revision as of 17:46, 18 September 2024 by Pas (talk | contribs) (Pas moved page ADDHOUR Function to ADDHOURS Function)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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


Go To

Retrieved from "http://planfix.com/help/index.php?title=ADDHOURS_Function&oldid=21908"