You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

ios numbers convert cell with number of days “54d” to plain number “54” so I can multiply against it

I’m trying to calculate how many gallons of water I run through a filter.


i know the number of days, and I know how much water I am putting in to be filtered


(Yes I can do this in calculator but I want to be able to see how many gallons total if I adjust the days and/or the amount of water added.)


See screenshot with red circles cell.


I subtract b2 from b3 to get total days in b4. i can’t find a cell formatting option to convert “54d” to just “54” so I can multiply in a simple formula to get my total gallons run through a filter in e5 that doesn’t show as duration.


I can manually enter the total days in d5 (see second screenshot with black circled cell) but it’s a spreadsheet not a Lego… any help appreciated. I’m trying to dump excel for home and business.

iPhone SE

Posted on Nov 18, 2024 5:30 PM

Reply
1 reply

ios numbers convert cell with number of days “54d” to plain number “54” so I can multiply against it

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.