How to compute hours with minute between two datetime fields?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
2
Replies
6100
Views
import datetime
date_string = "Wed, 18 Dec 2013 09:30:00 GMT"
date = datetime.datetime.strptime(date_string, "%a, %d %b %Y %H:%M:%S %Z")
end_date_string = "Wed, 18 Dec 2013 10:15:00 GMT"
end_date = datetime.datetime.strptime(end_date_string, "%a, %d %b %Y %H:%M:%S %Z")
print (end_date-date).seconds/60, "Minutes"
# Difference can get through substracting two datetime objects directly,
if you have input string then substract after converting to datetime object.
According to your input format change format in while strptime()
The following will work however i suggest you use the answer in your other question because the field that stores the diff can be added to a form with the float time widget to do what i think you are looking for.
time_diff = fields.Datetime.from_string(self.later_datetime) - fields.Datetime.from_string(self.earlier_datetime)
hours_diff = math.floor(round(float(time_diff.days) * 24 + (float(time_diff.seconds) / 3600)))
minute_diff = math.floor((time_diff-hours_diff)*60)
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
3
Jul 23
|
24341 | ||
|
2
Jun 22
|
4593 | ||
|
2
Sep 21
|
3480 | ||
|
1
Nov 20
|
6784 | ||
|
2
Mar 19
|
4977 |