Hi folks,
I have both excel and google sheets so can work with either.
I have created a spreadsheet to record my cardio things and the measurements are distance and duration of time.
Now I am using duration to record my times taken to do the exercise and have a cell that I want to display the total time of all the durations.
It works fine and counts up , however pnce it goes over 60 minutes it just counts up minutes.
I would like it to record instead of mins , hours and minutes
I have formatted the cell to [hh]:mm but 70 mins is still showing as 70:000
Eventually I would need to total of durations cell to show days/ hours and minutes
apologies if this is the wrong place for this post