iPad Numbers for iPad - formula help needed!

[martin2345uk]

Hi guys,

Really struggling with numbers…

I have a timesheet in Numbers on the iPad, one column is for hours, so 7h30 mins, 10h etc, and under it I just want to sum that column in hours.

The sum formula works, but when it goes over 24 hours it counts it in days and i need it to still count in hours…

Any ideas?

 

[mailbuoy]

Hi guys,

Really struggling with numbers…

I have a timesheet in Numbers on the iPad, one column is for hours, so 7h30 mins, 10h etc, and under it I just want to sum that column in hours.

The sum formula works, but when it goes over 24 hours it counts it in days and i need it to still count in hours…

Any ideas?

Check the cell formatting of the cell where you have summed. I just experimented on Numbers and I formatted the entire column as h m. When I sum a list of times the result is formatted h m, even when the sum is several days long.