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

## Bookmarks