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?