Need help with time hour calculator

How Should I Save Dates for a Simple Timecard Calculator?

Hi everyone,

I’ve built a timecard feature that works perfectly on the front end, allowing employees to input how much they’ve worked on a job. Now, I need to save this data to the back end and want to make sure I’m doing it the right way. It’s connected to the employees job. Usually I would start with backend for data however I rarely work with dates.

Here’s what I’m working with:

  • Employees fill out their time worked, including:
    • Start time
    • End time
    • Date
  • I’d like to calculate the total hours worked and store everything in the database. Probably use the sum

I hate working with dates its like my least favorite bubble thing here’s some images

How the front end works