Convert minutes to hundredths in Numbers

How do I convert Minutes to Hundredths in numbers?

MacBook Pro 16″, macOS 15.6

Posted on Jan 7, 2026 8:11 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 7, 2026 9:31 AM

If you mean something like 3:41 → 3.68h,

then the formula is: =HOUR(A1) + MINUTE(A1)÷60



Next, you can set the cell properties to force showing 2 decimals.

2 replies

Convert minutes to hundredths in Numbers

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