Time Total

This topic is locked

Time Total	1/30/2012 5:59:32 PM
PHPRunner General questions
P pimelimar author Dear all, On my List page I have Total of time. How can I get this Total per page only in hours and minutes (hhh:mm) For example: time of row1 = 20:30:00 time of row2 = 80:00:00 Total should be: 100:30:00, instead of 4d 04:30:00 Please help me


	kujox 3/3/2012
	Dear all, On my List page I have Total of time. How can I get this Total per page only in hours and minutes (hhh:mm) For example: time of row1 = 20:30:00 time of row2 = 80:00:00 Total should be: 100:30:00, instead of 4d 04:30:00 Please help me It depends on how you're storing the start and end time in the table, if it is in datetime format then insert a calculated field as follows `SELECT TIMEDIFF( end_time , start_time ) AS time FROM table` into the mysql section of PHP Runner