
Not applicable
2013-08-21
01:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How I can subtract minutes to format NOW?
I need to subtract 30 minutes to the current time to determine if information entered during each 30 minutes.
Thanks for your help.
1,693 Views
3 Replies

Partner - Champion III
2013-08-21
02:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
time(now() - 1/48,'hh:mm') will subtract 30 minutes, 1/48th part of a day, from now() and show it in hh:mm format
talk is cheap, supply exceeds demand
1,363 Views

MVP
2013-08-21
02:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try:
timestamp(now()-time#(30,'mm'))
or,
Timestamp(now()-30/24/60) // 1 means a day, hence 30 mins=30(1/24/60), or directly 1/48

Contributor II
2020-09-02
11:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Excuse me, I need to do the same thing but this time, I need to subtract 10 minutes to the current date. Considering your answer, I think It'd be something like this:
Now()-10/24/60
The thing is I don't understand the process. Can you explain it deeper?
I don't really get why i need to divide 30, 24 and 60.
1,105 Views
