I can't see where I can edit my post?
Anyways, this displays hours, minutes and seconds:
$query = mysql_query("SELECT SEC_TO_TIME(AVG(TIMESTAMPDIFF(SECOND, `firstcontactdate`,`dateadded`))) FROM leads WHERE userid = $userid AND firstcontactdate != '0000-00-00 00:00:00'");
$queryresult = mysql_fetch_array($query);
It would be good if I could get it to display the actual text 'hours', 'minutes' and 'seconds' too, any suggestions? I'm not familiar with MYSQL, I've looked at the dev guides.