Hi ~
I'd appreciate any help. I have a spreadsheet that has the number of used books in column A and the number of new books in column B.
We've determined that it takes about 90 seconds to prepare a book to be put on the shelves.
I want to find out how many hours and minutes (don't care about seconds) it would take to process the books.
Here's an emample. I've also attached a spreadsheet so you can see that my formula doesn't seem to work correctly. I would appreciate ANY help since I'm kind of at my wit's end. I'm using Excel 2003.
# Used Books | # New Books | Hours/Minutes for Used | Hours/Minutes for New |
3,915 | 566 | The formula I have in here is "=IF(A2=0,"",((A2)*90)/(60*60*24))" | The formula I have in here is "=IF(B2=0,"",((B2)*90)/(60*60*24))" |
3,703 | 474 | ||
2,076 | 238 |