Sum an hours & minutes column

A column has results in “Duration”

format, such as “4:30”, “3:45” etc.

I’m having trouble creating a cell formula or function that would sum them. (The intended use is to total the hours worked per week.)


This seems like it might require converting the hours:minutes to just minutes, summing them, and then converting back to hours:minutes? Or something like that?


Any help much appreciated by this near-total newbie.

Posted on Jan 13, 2024 1:08 PM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Sum an hours & minutes column

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