I have Clocking table in database. I wanted to count the users’ time spent per day.

For example 2024-03-21, user 1 spend 6.8 hours, the next day he spends n number of hours and so on (['6.8', 'n', ... 'n'])

This is my models.py

class Clocking(models.Model):
    user = models.ForeignKey('User', models.DO_NOTHING)
    timein = models.CharField(max_length=15, blank=True, null=True)
    timeout = models.CharField(max_length=15, blank=True, null=True)
    date = models.DateField(null=False)

I wanted to get the list of hours spent per day, which would be really useful for me in plotting charts.