Hi,

For instance, A1 = 8:20, B1 = 16:30.
I need to compute in C1 the following: B1 - A1 - 0.5 hour.

What is the formula?

If I use formula B1 - A1 - 0:30 I get invalid value.

Thanks,

--
Alex Vinokur
email: alex DOT vinokur AT gmail DOT com
http://mathforum.org/library/view/10978.html
http://sourceforge.net/users/alexvn

=B1-A1-TIME(0,30,0)

--
HTH

Bob Phillips

"Alex Vinokur" wrote in message
...
Hi,

For instance, A1 = 8:20, B1 = 16:30.
I need to compute in C1 the following: B1 - A1 - 0.5 hour.

What is the formula?

If I use formula B1 - A1 - 0:30 I get invalid value.

Thanks,

--
Alex Vinokur
email: alex DOT vinokur AT gmail DOT com
http://mathforum.org/library/view/10978.html
http://sourceforge.net/users/alexvn

"Bob Phillips" wrote in message ...
=B1-A1-TIME(0,30,0)

Thanks, Bob!

It works fine.

[snip]

--
Alex Vinokur
email: alex DOT vinokur AT gmail DOT com
http://mathforum.org/library/view/10978.html
http://sourceforge.net/users/alexvn

That's because time is really just a floating point number.

1 is 1 day
and hour is 1/24
a half hour is 1/48

=B1 - A1 - 1/48

will work just fine
--
Gary''s Student


"Alex Vinokur" wrote:

Hi,

For instance, A1 = 8:20, B1 = 16:30.
I need to compute in C1 the following: B1 - A1 - 0.5 hour.

What is the formula?

If I use formula B1 - A1 - 0:30 I get invalid value.

Thanks,

--
Alex Vinokur
email: alex DOT vinokur AT gmail DOT com
http://mathforum.org/library/view/10978.html
http://sourceforge.net/users/alexvn