The Billable worked, but the non billable doesn't seem to work....

where there is a 6 for the type of service (which is non billable), it comes
back with a 0 but we would like to know how much time we do spend that is non
billable for each client...

I feel your close to the answer......

my fingers are crossed....

--
thank you, Lorie


"Ragdyer" wrote:

Say you use Column K to show the type of service (1 - 6).
Say Column D is total time.
Column E is billable time.
Column F is non-billable.

To account for times that might cross midnight, enter this formula in D3:
=MOD(C3-B3,1)*1440

In E3 enter:
=(K3<6)*D3

In F3 enter:
=(K3=6)*D3

Then, select D3, E3, and F3,
And drag down the 3 cell selection to copy as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Lorie" wrote in message
...
My spread sheet that has start time and stop time, then total time worked
in
minutes using =(C3-B3)*1440
Here is the problem - that is total time.. We have to list the type of
service we are providing and we do that by entering 1-6 in another
column,
but only 1-5 is billable time, and 6 is Unbillable time. How can I
create a
column that will only show billable time in one column and non billable
time
in another column. Such as if in the one column were we enter the type
of
service (1 thru 6) the bill able time would only pull the data for the
numbers 1-5 and the non billable column will only pull those numbered 6.
I
can't seem to figure out a formula to do this.

Can any of you help me?


--
thank you, Lorie