I hope your not giving up on me.... *smile* I am still trying and i just am
not getting anywhere with the non billable time showing up.....the formula's
i try just aren't getting it... the one you gave me give's me a 0, but i need
to show the time that we do non billable stuff.....

Thank you for trying..... i keep checking back to see if you have replied
back again...
it is so frustrating to be so close, yet so far....

--
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