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.
What would be the formula for calculating pay earned? I have calculated total hours from start time and end time, but when I try to calculate pay earned from total hours multiplied by a dollar amount, the result appears in duration, not currency.
Thanks!
Tiffany
Try this:
DUR2HOURS(duration)*'Rate per hour formatted as currency'
DUR2HOURS, as the name implies, converts a Duration to the number of hours (and decimal fraction of an hour) expressed as a number. The recult is a number, which can be formatted a currency.
Regards,
Barry
Try this:
DUR2HOURS(duration)*'Rate per hour formatted as currency'
DUR2HOURS, as the name implies, converts a Duration to the number of hours (and decimal fraction of an hour) expressed as a number. The recult is a number, which can be formatted a currency.
Regards,
Barry
Yes! It worked!! Thank you!!
You are welcome.
Thanks for the green checkmark!
Regards,
Barry
Numbers timesheet
