Hi,

>I am trying to calculate worked hours for payment just like Excel does when a cell is
>formated as [HH:mm:ss].

You can have 2 TIMESTAMP fields: START_TIME and END_TIME. Than the worked hours will be:

(END_TIME-START_TIME)*24.0


I also have to calc worked time, but in minutes and with break time. I do like this:

((END_TIME-START_TIME) - COALESCE(END_BREAK-START_BREAK,0))*1440.0

I put this on a computed field and format to 'hhh:nn' with a simple function at client side.


Regards,
Anderson Farias


[Non-text portions of this message have been removed]