Hi,

> I would like the following result.
>
> 01:00 + 03:30 + 01:45 = 06:15
>
> would return only the sum
>
> no matter whether it is morning or evening, this field saves time
> allotted and not hours

You cannot "sum" time, you can only "sum" duration.

The data type TIME stored "time of day", which is different.

If you have chosen to store "time allotted", basically "duration" into
a TIME field, then you have choosen the wrong data type.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com