Hello,

I'm having a problem when i try to SUM time value (HH:MM:SS).
user inserts the time he spend doing some job. then the report shows how much time he spend on doing all jobs duringso i got a subtotal on day and on month but it does not seems to work ir does not summarize time.

is there a format that i could use to SUM time?

thanks in advance

This message has been edited. Last edited by: Kerry,

If you are using a date/time field and you have a start date/time and end date/time try using the HDIFF function. Otherwise you'll have to convert the start time string (10:30am) to minutes from midnight and do the same for the stop time string and substract the two.