So I have this “work blog” that I created for my team. It's meant to be very simple for all the admins to put in what they've done, from the menial (added user to distro list) to the major (implemented SMS 2.0). It has “entry”, “details”, Category (radio buttons) and importance (low/med/high). It helps me do the weekly status reports.
An optional field is “minutes“. I also have a caculated field which is minutes/60 so I can see estimated work hours.
I also have three views -- one which is just “most recent first“, which functions like a normal blog, another view which is some details by employee, and another which is Work by category -- which would show about how much work hours done in the week, by category.
Problem is -- I can't do a “total“ by this calculated field. I can only do it if I also display the minutes, and then total them up. But I don't want minutes displayed, I want work hours, and that's the whole reason I created the calculated field.
Any workarounds?
Here are some sample pics:
