Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check if a number is integer or fraction | New Users to Excel | |||
How do I keep excel from changing the a fraction to a whole number | Excel Discussion (Misc queries) | |||
date has fraction instead of whole number | Excel Discussion (Misc queries) | |||
formula for converting decimal to inch & fraction | Excel Discussion (Misc queries) | |||
Display ONLY fraction portion of number | Excel Discussion (Misc queries) |