Hi

Standard durationformula for work past midnight -or not- is
=B1-A1+(B1<A1)
-I think they deserve a paid break working hours like that ;-)

HTH. Best wishes harald

"mats" skrev i melding
...
i have a problem when wanting to calculate time using 24 hour clock, i
have
attached a simple example:

These are the columns & row 1:
A B C D
E
Start Finish Time of break Break length Hours
8:00 18:00 13:00 1.00 9.00
23:00 7:00 2:00 1.00 ERROR

I want to be able to use it for night time hours, the example that is
there,
I want to calculate from 11pm to 7am, with 1 hour break at 2am, how can I
do
this?
The formula that i am using is as follows: Format of cells is 13:30
=IF(B1-A1<0,"ERROR",((B1-A1)*24)-D1)