Change duration format to hour

[eruiui23]

I have a time tracker to track how many hours I spent to do an activity.

After one of my activity reaches 24 hours. it displayed using day. I want it to display them as hours (like steam hours played).

I currently use this dataview query that I discovered on obsidian forum

TABLE WITHOUT ID sum( filter(flat(rows.SE), (r) => typeof(r) = "duration" )) as "Total Time Spent" 
FROM #Daily 
GROUP BY true

Things I tried

• changing “duration” to “duration.hours”

[DiCaver]

Try this …

TABLE WITHOUT ID 
round(sum(filter(flat(rows.SE), (r) => typeof(r) = "duration")) / dur(1 hour), 2) as "Total Time Spent (h)"
FROM #Daily 
GROUP BY true

… I’m not behind the computer to properly test it

Cheers, Marko

[cheezopath]

=dur(450 minutes) = 7 hours, 30 minutes
=dur(450 minutes).hour = 7.5

[eruiui23]

unfortunately this doesnt work, and this error comes out

[holroy]

Why do you divide by a duration? What is your current query which gives this error?

What do you get with this variation:

```dataview 
TABLE WITHOUT ID sum( filter(flat(rows.SE), (r) => typeof(r) = "duration" )).hour as "Total Time Spent" 
FROM #Daily 
GROUP BY true
```

[DiCaver]

Maybe if we see the source, it would be easier. As with “duration”, I’m unsure what/where/how you’re getting it.

You can read more about it here: Literals - Dataview

And how to format duration, here: Functions - Dataview

Cheers, Marko

[eruiui23]

1. Sorry I dont quite understand your first question,

2. the query that gives the error above is this one

TABLE WITHOUT ID 
round(sum(filter(flat(rows.SE), (r) => typeof(r) = "duration")) / dur(1 hour), 2) as "Total Time Spent (h)"
FROM #Daily 
GROUP BY true

3. Using your variation I get this
   
   

which is cool (thx)
is there a way to put the word “hours” behind the numbers?

[eruiui23]

I use properties on my daily notes, like this

[eruiui23]

I found what Im looking for, thx for all the help

[holroy]

Just change the .hour as "Total... part to .hour + " hours" as "Total....