
Contributor III
2020-09-22
03:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add +2 hours to a timestamp
Hello,
I want to add 2 hours to a timestamp (I cannot change it in the database).
The timestamp looks like this 2020-09-22 06:30:02.000000 (YYYY-MM-DD hh:mm:ss.miliseconds)
4,063 Views
1 Solution
Accepted Solutions

MVP
2020-09-22
03:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@jisephcirspy like :
=timestamp(Date#('2020-09-22 06:30:02.000000','YYYY-MM-DD hh:mm:ss.ffffff') + 2/24)
Example : 2020-09-22 06:30:02.000000
output:
2/24-> Nbofhour/24
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
2 Replies

MVP
2020-09-22
03:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@jisephcirspy like :
=timestamp(Date#('2020-09-22 06:30:02.000000','YYYY-MM-DD hh:mm:ss.ffffff') + 2/24)
Example : 2020-09-22 06:30:02.000000
output:
2/24-> Nbofhour/24
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉

Contributor III
2020-09-22
04:49 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you very much @Taoufiq_Zarra !!! helped me a lot
