05-10-2006, 17:21
|
#15
|
|
Inactive
Join Date: Jun 2006
Location: Cambridge
Services: Sky TV, VM TV, 20meg bb, tel, and a lobster (but the lobster died).
Posts: 4,349
|
Re: Another Excel question!
Quote:
Originally Posted by gazzae
Seems like I was to slow.
This is how I would have done it.
Code:
=IF(A3>TEXT("07:30","HH:MM"),0,TEXT("07:30","HH:MM")-A3)+IF(B3>TEXT("18:30","HH:MM"),0,B3-TEXT("18:30","HH:MM"))
|
I like this! In fact, one of the things I like about Excel is that there are so many ways to solve a problem. Wonderful software - thanks Bill.
|
|
|