Anonymous
Not applicable
2015-05-19
10:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Finding number of hours between dates
How do I find the number of hours from yesterday and now ?
Lets say hours between
2015-05-17 23:59:02 and now()
I must be able to validate this formula using a textbox
543 Views
1 Solution
Accepted Solutions
robert_mika
Master III
2015-05-19
11:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=(now()-'2015-05-17 23:59:02')*24
394 Views
2 Replies
robert_mika
Master III
2015-05-19
11:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=(now()-'2015-05-17 23:59:02')*24
395 Views
Not applicable
2015-05-19
01:13 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you could also try this:
=interval(now()-'2015-05-17 23:59:02','hh')