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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
In Apple Pages, I have a table set up as follows:
Could you please guide me on how to set this up correctly, including any necessary cell formatting and the formulas I need to use?
Cell A1
Click on this cell and select Cell Data Format to Duration using Custom Units of hr | min.
Enter the duration as (e.g. 336h 0m).
Cell A2
Click on this cell and select Cell Data Format to Currency, 2 Decimals, and optionally thousands separator and Accounting Style.
Enter cost as 50
Cell A3
Click on this cell and select Cell Data Format to Currency, same as Cell A2.
Enter the formula by typing = and then entering A1 * A2 and click the green checkmark in the equation panel.
The calculation will immediately appear as:
It is better to reserve a cell for the cost in case it changes rather than embed the cost into a formula.
Tested: Pages v14.2, macOS Sequoia v15.0.1
Thank you! I was try to put the $50 in the formula so there would only be two cells.
DefinedDesign wrote:
Thank you! I was try to put the $50 in the formula so there would only be two cells.
Purely your choice…
Need Your Apple Pages Expertise: Calculating Costs from Durations!
