How do I convert datetime.timedelta to minutes, hours in Python?

by

There’s no built-in formatter for timedelta objects, but it’s pretty easy to do it yourself:

days, seconds = duration.days, duration.seconds
hours = days * 24 + seconds // 3600
minutes = (seconds % 3600) // 60
seconds = seconds % 60

Or, equivalently, if you’re in Python 2.7+ or 3.2+:

seconds = duration.total_seconds()
hours = seconds // 3600
minutes = (seconds % 3600) // 60
seconds = seconds % 60

Now you can print it however you want:

'{} minutes, {} hours'.format(minutes, hours)

For example:

def convert_timedelta(duration):
    days, seconds = duration.days, duration.seconds
    hours = days * 24 + seconds // 3600
    minutes = (seconds % 3600) // 60
    seconds = (seconds % 60)
    return hours, minutes, seconds
td = datetime.timedelta(2, 7743, 12345)
hours, minutes, seconds = convert_timedelta(td)
print '{} minutes, {} hours'.format(minutes, hours)

This will print:

9 minutes, 50 hours

If you want to get “10 minutes, 1 hour” instead of “10 minutes, 1 hours”, you need to do that manually too:

print '{} minute{}, {} hour{}'.format(minutes, 's' if minutes != 1 else '',
                                      hours, 's' if minutes != 1 else '')

Or you may want to write an english_plural function to do the 's' bits for you, instead of repeating yourself.

From your comments, it sounds like you actually want to keep the days separate. That’s even easier:

def convert_timedelta(duration):
    days, seconds = duration.days, duration.seconds
    hours = seconds // 3600
    minutes = (seconds % 3600) // 60
    seconds = (seconds % 60)
    return days, hours, minutes, seconds

If you want to convert this to a single value to store in a database, then convert that single value back to format it, do this:

def dhms_to_seconds(days, hours, minutes, seconds):
    return (((days * 24) + hours) * 60 + minutes) * 60 + seconds

def seconds_to_dhms(seconds):
    days = seconds // (3600 * 24)
    hours = (seconds // 3600) % 24
    minutes = (seconds // 60) % 60
    seconds = seconds % 60
    return days, hours, minutes, seconds

So, putting it together:

def store_timedelta_in_database(thingy, duration):
    seconds = dhms_to_seconds(*convert_timedelta(duration))
    db.execute('INSERT INTO foo (thingy, duration) VALUES (?, ?)',
               thingy, seconds)
    db.commit()

def print_timedelta_from_database(thingy):
    cur = db.execute('SELECT duration FROM foo WHERE thingy = ?', thingy)
    seconds = int(cur.fetchone()[0])
    days, hours, minutes, seconds = seconds_to_dhms(seconds)
    print '{} took {} minutes, {} hours, {} days'.format(thingy, minutes, hours, days)

More Related Contents:

  1. How to pull a random record using Django’s ORM?
  2. Django 1.7 throws django.core.exceptions.AppRegistryNotReady: Models aren’t loaded yet
  3. How do I perform HTML decoding/encoding using Python/Django?
  4. How to send email via Django?
  5. Get Timezone from City in Python/Django
  6. How to replace Django’s primary key with a different integer that is unique for that table
  7. multiple django sites with apache & mod_wsgi
  8. Django Unique Together (with foreign keys)
  9. Django : Table doesn’t exist
  10. django – convert a list back to a queryset [duplicate]
  11. How do I separate my models out in django?
  12. django best approach for creating multiple type users
  13. When should I use escape and safe in Django’s template system?
  14. Using request.user with Django ModelForm
  15. How to execute arithmetic operations between Model fields in django
  16. gunicorn autoreload on source change
  17. What is the best approach to change primary keys in an existing Django app?
  18. Order of Serializer Validation in Django REST Framework
  19. Difference between AbstractUser and AbstractBaseUser in Django?
  20. How to expire Django session in 5minutes?
  21. Django Admin – Disable the ‘Add’ action for a specific model
  22. Django equivalent of PHP’s form value array/associative array
  23. How can I set a default value for a field in a Django model?
  24. django filter on the basis of text length
  25. Detect whether Celery is Available/Running
  26. How to assign a local file to the FileField in Django?
  27. Why is my static CSS not working in Django?
  28. Django: Serving Media Behind Custom URL
  29. Writable nested serializer in django-rest-framework?
  30. How to annotate Count with a condition in a Django queryset

Leave a Comment