Skip to Content
Menu
This question has been flagged
2 Replies
6100 Views

How to compute hours with minute between two datetime fields?

Avatar
Discard
Best Answer
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()
Avatar
Discard
Best Answer


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)
Avatar
Discard
Related Posts Replies Views Activity
3
Jul 23
24341
2
Jun 22
4593
2
Sep 21
3480
1
Nov 20
6784
2
Mar 19
4977