I’m trying to build a webpage that shows a table displaying time spent on a project (by date). I have 3 fields in MySQL: Date, Start Time, and End Time. I can build a page with php that connects to the MySQL database and then shows each date with the start and end times, but how can I get it to calculate/display the number of minutes spent each day as well as the total number of minutes overall? I can’t seem to get it to calculate the minutes…
Thanks
Matt