Hello. I am using a timediff to get the time taken on a job from two fields. Sometimes I need to apply the time plus half or double time but I can not seem to find a way to do this. At the moment I have (select timediff(start,end)) as time, and that part works, but I then try (select time_to_sec(@time)) as sec, but I don't get any values. Any ideas please? Thanks paul.