I have already had very good help, but unfortunately, none of the solutions
which can handle the needs I have to consider.

I can only make a form that works properly, either when finishing is before
24:00 or after 24:00. I can not make a form that can handle END times both
before and after 24:00.

So I have to just to try once mo)

I would be very happy if I could get help to produce a formula which is able
to calculate hours in a time when "finishing" can be both before and after
at. 24:00.

I can only make a formular, who works

For example: Start: 16:00, End: 6:00 total hours = 14 ,
and hours of these between 18:00 to 22:00 = 4

and another example: Start: 16:00, End: 21:00 total hours = 6,
and hours of these between 18:00 to 22:00 = 3

It is the counting of the time between 18:00 and 22:00 there is a problem,
totaltid is not necessary to count.

Sincerely,
H. Nissen

Hi,

Try this
=(B1-A1+(B1<A1))*24

Start time In A1
End time In B1

A1 and B1 can be on the same day or roll over midnight and it will give the
difference in hours.

Mike

"H. Nissen" wrote:

I have already had very good help, but unfortunately, none of the solutions
which can handle the needs I have to consider.

I can only make a form that works properly, either when finishing is before
24:00 or after 24:00. I can not make a form that can handle END times both
before and after 24:00.

So I have to just to try once mo)

I would be very happy if I could get help to produce a formula which is able
to calculate hours in a time when "finishing" can be both before and after
at. 24:00.

I can only make a formular, who works

For example: Start: 16:00, End: 6:00 total hours = 14 ,
and hours of these between 18:00 to 22:00 = 4

and another example: Start: 16:00, End: 21:00 total hours = 6,
and hours of these between 18:00 to 22:00 = 3

It is the counting of the time between 18:00 and 22:00 there is a problem,
totaltid is not necessary to count.

Sincerely,
H. Nissen

If Start is in col K, End in col L then try
=IF(L2K2,L2,1+L2)-K2

Regards,
Stefi
€žH. Nissen€� ezt Ã*rta:

I have already had very good help, but unfortunately, none of the solutions
which can handle the needs I have to consider.

I can only make a form that works properly, either when finishing is before
24:00 or after 24:00. I can not make a form that can handle END times both
before and after 24:00.

So I have to just to try once mo)

I would be very happy if I could get help to produce a formula which is able
to calculate hours in a time when "finishing" can be both before and after
at. 24:00.

I can only make a formular, who works

For example: Start: 16:00, End: 6:00 total hours = 14 ,
and hours of these between 18:00 to 22:00 = 4

and another example: Start: 16:00, End: 21:00 total hours = 6,
and hours of these between 18:00 to 22:00 = 3

It is the counting of the time between 18:00 and 22:00 there is a problem,
totaltid is not necessary to count.

Sincerely,
H. Nissen

Hi Steffi

Hello Steffi

I think I have been too bad to explain my problem. It is not the total time
there is the problem, but when you have a timescale for example. from 16:00
to 6:00 then I find out how many hours in the time span between 18:00 and
22:00.

For example: 16:00 to 06:00 = between 18:00 and 22:00 4 hours
And
For example: 16:00 to 21:00 = between 18:00 and 22:00 3 hours.

In excel sheet enter 16:00 and 6:00 and then excel automatically calculate
how many hours are between 18:00 and 22:00.

I hope this explains my problem a little better:)

Sincerely,
H. Nissen


"Stefi" wrote:

If Start is in col K, End in col L then try
=IF(L2K2,L2,1+L2)-K2

Regards,
Stefi
€žH. Nissen€� ezt Ã*rta:

I have already had very good help, but unfortunately, none of the solutions
which can handle the needs I have to consider.

I can only make a form that works properly, either when finishing is before
24:00 or after 24:00. I can not make a form that can handle END times both
before and after 24:00.

So I have to just to try once mo)

I would be very happy if I could get help to produce a formula which is able
to calculate hours in a time when "finishing" can be both before and after
at. 24:00.

I can only make a formular, who works

For example: Start: 16:00, End: 6:00 total hours = 14 ,
and hours of these between 18:00 to 22:00 = 4

and another example: Start: 16:00, End: 21:00 total hours = 6,
and hours of these between 18:00 to 22:00 = 3

It is the counting of the time between 18:00 and 22:00 there is a problem,
totaltid is not necessary to count.

Sincerely,
H. Nissen

Hi Mike H.

Thx for your answeer, pls. see my reply to Stefi :)

Kinds regards
H. Nissen

"Mike H" wrote:

Hi,

Try this
=(B1-A1+(B1<A1))*24

Start time In A1
End time In B1

A1 and B1 can be on the same day or roll over midnight and it will give the
difference in hours.

Mike

"H. Nissen" wrote:

I have already had very good help, but unfortunately, none of the solutions
which can handle the needs I have to consider.

I can only make a form that works properly, either when finishing is before
24:00 or after 24:00. I can not make a form that can handle END times both
before and after 24:00.

So I have to just to try once mo)

I would be very happy if I could get help to produce a formula which is able
to calculate hours in a time when "finishing" can be both before and after
at. 24:00.

I can only make a formular, who works

For example: Start: 16:00, End: 6:00 total hours = 14 ,
and hours of these between 18:00 to 22:00 = 4

and another example: Start: 16:00, End: 21:00 total hours = 6,
and hours of these between 18:00 to 22:00 = 3

It is the counting of the time between 18:00 and 22:00 there is a problem,
totaltid is not necessary to count.

Sincerely,
H. Nissen

Assuming Start Time is in cell A2, End time is in cell B2, the exception
start time (18:00) in cell C2, and the exception end time (22:00) in cell D2.
NOTE: for c2 and d2, if these are standard, you can put in the actual
value....
Also, 16:00 to 21:00 is 5 hours, not 6.

But here is a formula:

=(MIN(IF(B2<A2,B2+1,B2),IF(D2<C2,D2+1,D2))-MAX(A2,C2))*24

--
John C


"H. Nissen" wrote:

I have already had very good help, but unfortunately, none of the solutions
which can handle the needs I have to consider.

I can only make a form that works properly, either when finishing is before
24:00 or after 24:00. I can not make a form that can handle END times both
before and after 24:00.

So I have to just to try once mo)

I would be very happy if I could get help to produce a formula which is able
to calculate hours in a time when "finishing" can be both before and after
at. 24:00.

I can only make a formular, who works

For example: Start: 16:00, End: 6:00 total hours = 14 ,
and hours of these between 18:00 to 22:00 = 4

and another example: Start: 16:00, End: 21:00 total hours = 6,
and hours of these between 18:00 to 22:00 = 3

It is the counting of the time between 18:00 and 22:00 there is a problem,
totaltid is not necessary to count.

Sincerely,
H. Nissen

Hello John C

There it was, exactly what I was missing. I owe you a big thank you for your
kind assistance. Thank you:)

With warm regards,
Hans N.

PS! You are totally right, 16 = 21 is 5, not 6, you now understand why i
need the timecalculator? :-)





"John C" skrev:

Assuming Start Time is in cell A2, End time is in cell B2, the exception
start time (18:00) in cell C2, and the exception end time (22:00) in cell D2.
NOTE: for c2 and d2, if these are standard, you can put in the actual
value....
Also, 16:00 to 21:00 is 5 hours, not 6.

But here is a formula:

=(MIN(IF(B2<A2,B2+1,B2),IF(D2<C2,D2+1,D2))-MAX(A2,C2))*24

--
John C


"H. Nissen" wrote:

I have already had very good help, but unfortunately, none of the solutions
which can handle the needs I have to consider.

I can only make a form that works properly, either when finishing is before
24:00 or after 24:00. I can not make a form that can handle END times both
before and after 24:00.

So I have to just to try once mo)

I would be very happy if I could get help to produce a formula which is able
to calculate hours in a time when "finishing" can be both before and after
at. 24:00.

I can only make a formular, who works

For example: Start: 16:00, End: 6:00 total hours = 14 ,
and hours of these between 18:00 to 22:00 = 4

and another example: Start: 16:00, End: 21:00 total hours = 6,
and hours of these between 18:00 to 22:00 = 3

It is the counting of the time between 18:00 and 22:00 there is a problem,
totaltid is not necessary to count.

Sincerely,
H. Nissen