About Us

Bibi

hmm thought as much :S

thanks for your quick response.

"Don Guillett" wrote:

suggest you re-arrange into columns
a
time in
b
time out
etc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bibi" wrote in message
...
I am putting together a timesheet - see example

Col D Col E
11 Time In 8:30 AM
12 Time Out 12:30 PM
13 Hours 4.0
14 Rate 1.5
15 Meal Break
16 Time In 1:00 PM
17 Time Out 3:00 PM
18 Hours 2.0
19 Rate 2.0
20 Total @ 1.5 0.5
21 Total @ 2.0 6.0

In E20, I wanted to calculate the number of hours worked where rate = 1.5
(similar for E21 but for rate=2.0)

I tried SUMIF, but it gave odd results (results expected should have been
4
hours @ 1.5 and 2 hours @ 2.0) using =SUMIF(E11:E19,1.5,E13) and
=SUMIF(E11:E19,2.0,E13) respectively.

A) - I cannot have more than 2 cells in the sumrange as they are not
adjacent
B) - SUMIF results are dependent upon results of other formulae in the
cells
C) - results not expected

Help anyone? Sorry if this is clear as mud.

Its a bit complicated but

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help! Totally Grey Sheet	nabanco	Excel Worksheet Functions	2	August 2nd 07 07:16 PM
Totally wierd	Fritz	Excel Worksheet Functions	4	July 23rd 07 01:44 PM
Finding text in one field, and then totally another	Tom D[_3_]	Excel Worksheet Functions	1	April 27th 07 12:57 AM
Totally Stumped	Sondra	Excel Discussion (Misc queries)	3	February 15th 06 02:01 PM
Help!!! Pivot table from mac goes totally blank on pc.	[email protected]	Excel Discussion (Misc queries)	0	May 31st 05 09:30 PM

Menu

About Us