I maintain a log to record my running (as in, jogging) data. One column is the duration of a run. I have had no luck figuring out how to format this data in Numbers so that I can sum up the total number of hours, minutes, and seconds in another cell for a weekly total. Any suggestions?
iMac, Mac OS X (10.7.2)
enter the running duration as an actual duration (the format is 4h 30m 21s)
assuming you enter data like this in column C, you can add a footer (or header) row, then use the formula:
=sum(C)
to add up the total duration
enter the running duration as an actual duration (the format is 4h 30m 21s)
assuming you enter data like this in column C, you can add a footer (or header) row, then use the formula:
=sum(C)
to add up the total duration
Thank you, Wayne. That does the trick!
Were there any posts that solved your question?
durations are a built-in data type and have a family of functions that can be used to convert them to decimal numbers.
all of these can be used to assist in making calculations
Summing running time
