I am trying to sum up all working hours from my notes in time format, like 01:45 (for 1 hour and 45 minutes)
Things I have tried
I have tried the following with the tracker plugin:
searchType: frontmatter
searchTarget: Translation
folder: Journal
summary:
template: ‘Total hours spent: {{sum()}} hours’
With this I am getting some wrong numbers. I also tried this:
searchType: dvField
searchTarget: Translation
folder: Journal
xDataset: 0
summary:
template: ‘Total hours spent: {{sum}} hours’
But then I get the message: No valid date as X value found in notes 25 files are not in the right format.
Do I have to use another time format or do I have to change something else? Any help would be greatly appreciated!