I have this table with time for each row. It shows hh:mm.
I have rows with all kind of time, 6:30, 5:10, 5:00, 6:42 etc, and I have to multiply it by the hourly rate.
Could you please help me?
I think I have to, first convert this time column into a number so I can multiply it with the hourlyRate, right? How do i do this in mysql?
OR, is it better to split and add both after the multiplication? Can you help me on how to do it?
Thank you all in advance