=((end_time-start_time)+if(end_time<start_time,1,0))*24
or shorter:
=((end_time-start_time)+(end_time<start_time))*24

Another option would be to include the time and date for each entry.

Aline wrote:

Thanks Bob,

But it does not work on my example. For instance, starting time is
22.00hr, end time 06.00 hr; total worked hours would have to result in
8 hrs.

Bob Phillips schreef:

=(end_time-start_time)*24

--
HTH

Bob Phillips

"Aline" wrote in message
oups.com...
Hello!

Does anyone know how you can calculate worked hours in a day on the
basis of a start and end time?


--

Dave Peterson