iPad Numbers on iPadOS 14 - Adding times

[return2sendai]

Hi,

I want to add times. I can add 5h, 5h 30m, 5h, 5h, and 4h 30m, but the formula gives me 1d 1h. I want the formula to give me 25h 0m. I want the answer in hours and minutes. Not days, hours, and minutes. See attached. Any ideas?

Cheers,
Martin

 

[0128672]

Are you selecting the formula for that cell as this after turning off Automatic Units?

 

[return2sendai]

Are you selecting the formula for that cell as this after turning off Automatic Units?

View attachment 961584

A-ha! Thank youuuuuuuuu!