Converting the whole number to a fraction
 

I need to be able to count the number 1 as .25 or 1/4 of an hour worked. For
example: if I parked 1 blue car it would take .25 or 1/4 of an hour. If I
parked 1 blue car and 3 green cars it would take 1 hour. I don't need the
total number of cars parked just how long it takes. O55 is the hours block
and O13, O17, O21, O25, O29, O33, O37, O41, O45 and O49 are the cars. Any
help would be greatly appriciated.

Thanks, 64E

Converting the whole number to a fraction
 

You could just ass the cars up and multiply by 0.25

=SUM(O13,O17,O21,O25,O29,O33,O37,O41,O45,O49)*0.25

Mike

"wsmith_1464E" wrote:

I need to be able to count the number 1 as .25 or 1/4 of an hour worked. For
example: if I parked 1 blue car it would take .25 or 1/4 of an hour. If I
parked 1 blue car and 3 green cars it would take 1 hour. I don't need the
total number of cars parked just how long it takes. O55 is the hours block
and O13, O17, O21, O25, O29, O33, O37, O41, O45 and O49 are the cars. Any
help would be greatly appriciated.

Thanks, 64E

Converting the whole number to a fraction
 

From your description, it looks like all you have to do is multiply the
total number of cars by 0.25. If I read your description correctly, that
total would seem to be in O55... if that is correct, I think all you need is
this...

=0.25*O55

Rick


"wsmith_1464E" wrote in message
...
I need to be able to count the number 1 as .25 or 1/4 of an hour worked.
For
example: if I parked 1 blue car it would take .25 or 1/4 of an hour. If I
parked 1 blue car and 3 green cars it would take 1 hour. I don't need the
total number of cars parked just how long it takes. O55 is the hours block
and O13, O17, O21, O25, O29, O33, O37, O41, O45 and O49 are the cars. Any
help would be greatly appriciated.

Thanks, 64E

Converting the whole number to a fraction
 

Thanks,

It worked perferct. Makes me feel dumb after seeing how easy it is.

Thanks, again.

"Mike H" wrote:

You could just ass the cars up and multiply by 0.25

=SUM(O13,O17,O21,O25,O29,O33,O37,O41,O45,O49)*0.25

Mike

"wsmith_1464E" wrote:

I need to be able to count the number 1 as .25 or 1/4 of an hour worked. For
example: if I parked 1 blue car it would take .25 or 1/4 of an hour. If I
parked 1 blue car and 3 green cars it would take 1 hour. I don't need the
total number of cars parked just how long it takes. O55 is the hours block
and O13, O17, O21, O25, O29, O33, O37, O41, O45 and O49 are the cars. Any
help would be greatly appriciated.

Thanks, 64E

Converting the whole number to a fraction
 

your welcome and thanks for the feedback

"wsmith_1464E" wrote:

Thanks,

It worked perferct. Makes me feel dumb after seeing how easy it is.

Thanks, again.

"Mike H" wrote:

You could just ass the cars up and multiply by 0.25

=SUM(O13,O17,O21,O25,O29,O33,O37,O41,O45,O49)*0.25

Mike

"wsmith_1464E" wrote:

I need to be able to count the number 1 as .25 or 1/4 of an hour worked. For
example: if I parked 1 blue car it would take .25 or 1/4 of an hour. If I
parked 1 blue car and 3 green cars it would take 1 hour. I don't need the
total number of cars parked just how long it takes. O55 is the hours block
and O13, O17, O21, O25, O29, O33, O37, O41, O45 and O49 are the cars. Any
help would be greatly appriciated.

Thanks, 64E