Once more with timetables

A

an

I would like to have a versatil formulae to work between
four moments. START - BREAK - RETURNNING - TO LEAVE
If four cells they will have data it's ok. A formulae it
could be:

1ª Hypothesis
START - BREAK - RETURNNING - TO LEAVE
=D2-A2+(D2>A2)-(C2-B2+(C2>B2))

But if:

2ª Hypothesis
NOT BREAK and NOT RETURNNING, (START ....... TO LEAVE)

3ª Hypothesis
START - BREAK and NOT RETURNNING

It's more complicated, for me.

I would like your help for this, please.
Thanks in advance.
an
 
J

JulieD

Hi an

as long as you don't go over a 24 hr period the following should work
=((D2-A2)-(C2-B2))*24

Cheers
JulieD

I would like to have a versatil formulae to work between
four moments. START - BREAK - RETURNNING - TO LEAVE
If four cells they will have data it's ok. A formulae it
could be:

1ª Hypothesis
START - BREAK - RETURNNING - TO LEAVE
=D2-A2+(D2>A2)-(C2-B2+(C2>B2))

But if:

2ª Hypothesis
NOT BREAK and NOT RETURNNING, (START ....... TO LEAVE)

3ª Hypothesis
START - BREAK and NOT RETURNNING

It's more complicated, for me.

I would like your help for this, please.
Thanks in advance.
an
 
A

an

Ok, JulieD

Thanks for your reply.
Only two otherwises:

1 - The result in Number Type. When format to HH:MM,
change the result;
2 - If delete data in RETTURNING but stay in place, withou
work (to informative situation), return error on result.

However, many thanks.
an
 
J

JulieD

Hi an

if you want the answer in HH:MM change it to
=(D2-A2)-(C2-B2)

and i'm sorry i don't understand you're second point.

Cheers
JulieD


Ok, JulieD

Thanks for your reply.
Only two otherwises:

1 - The result in Number Type. When format to HH:MM,
change the result;
2 - If delete data in RETTURNING but stay in place, withou
work (to informative situation), return error on result.

However, many thanks.
an
 
Top