MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos
format
Search

How Could I SUM the Time Format 00:00 (hr:min) In Numbers?

Thursday January 20, 2022. 06:47 PM , from MacMost
I have downloaded from external app a driving duration report. It gives me the values only in for example 01:12
Which would be 1 hour and 12 min. I would like to SUM all the columns to get the monthly driving report in hours, minutes, sec.
When I choose in Numbers under “Cells” → “Data Format” → “Duration”, it reads it as minutes and seconds.
I tried to add format as 01:12:00 ( which would be 1 hour 12 minutes and zero sec ) it reads automatically as a date, but after switching to a custom units hr min sec nothing happens, it doesn’t change.
—–
Joze, Germany
https://macmost.com/forum-how-could-i-sum-the-time-format-0000-hrmin-in-numbers.html
News copyright owned by their original publishers | Copyright © 2004 - 2024 Zicos / 440Network
Current Date
Apr, Thu 25 - 08:12 CEST