Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |