You’re offline. This is a read only version of the page.
Announcements
83
Hi,
I am trying to find a formula to add hours to a date/time value field - for ex. I would like to add 2 hours from now as deadline for a job to be completed. I could see Dataadd function, but this one looks like add only years, months or days, not hours or minutes.
My jobs are due to finish in hours or minutes, not days 🙂
Is there any chance to achieve this?
Thank you!
Date/time is measured in days, so for example the formula
Now() + 1
is tomorrow. Or
Now() + 0.5 is 12 hours in the future.
So to add 1 hour, use
Now() + 1/24
for example. To add a minute, use
Now() + 1/(24*60)
Share
Report
All responses (
Answers (
