How to pull "available hours" into a report? Need to compare "counts as revenue" hours to total hours available.

Forum|Forum|1 month ago
February 20, 2026
2 replies
41 views

I’ve set up reports to show “counts as revenue” hours vs total recorded hours, but since we have not required employees to fill up their time sheets, a lot of them don’t record non-revenue hours. We can change that through training but in the meantime I would like to create a report that shows revenue hours vs total available hours. But when I’m trying to build the report, don’t see any option for an “Available Hours” column. Do I need to do this in text mode? If so, how would that be parsed? I don’t use text mode a lot, and when I do it’s mostly finding something that looks similar to what I want and copying or editing it.

Thanks in advance.

Best answer by KellieGardner

Thanks for the additional context. The easiest approach will be to create a text mode calculation to handle this for you.

Keep in mind, however, that this method will not account for holidays or any time off if hours are being logged. If that level of detail isn’t required, you can apply a standard 40-hour baseline across the board.

The exact field reference will vary depending on the report and object you’re using, but the basic syntax would look like this:

valueexpression={field name}/40

KellieGardner

Community Advisor and Adobe Champion

What is the definition of available hours you are trying to get?

Have you looked into workload balancer or planner to get that visual without using reporting?

M

mdeancherryAuthor

Level 3

Kellie,

Ideally “available hours” would be based on the schedule (from the Set-Up → Schedules section) so, 40 hours most week but 24 (or whatever) Christmas week, etc. Basically, 40 minus corporate recognized holidays. Really, if it was just “40” it would get me into the ballpark. And we want to use reporting because balancer doesn’t display the information the way I’m looking for, e.g., last month 60% of available hours were billable, this month 70% are, etc.

Like I mentioned, I’ve got a chart that shows billable vs non-billable for recorded hours but not everyone records 40 hours so that’s misleading if you don’t think about what exactly is being displayed.

KellieGardner

Accepted solution

Community Advisor and Adobe Champion

Thanks for the additional context. The easiest approach will be to create a text mode calculation to handle this for you.

Keep in mind, however, that this method will not account for holidays or any time off if hours are being logged. If that level of detail isn’t required, you can apply a standard 40-hour baseline across the board.

The exact field reference will vary depending on the report and object you’re using, but the basic syntax would look like this:

valueexpression={field name}/40

M

MattWindsor

Level 3

If you’re unable to use planner to get what you needed (I couldn’t a few months ago), then I had to make do with a work-around.

I wanted the available hours for a monthly utilisation report but after investigating, couldn’t get this into a report. In the end I exported the data I needed which included daily working hours from each users profiles. Not sure if you have this available.

Then in Excel, I had to generate the available working hours per individual based on days per calendar month they could have worked. That gave me my base, so I could work out Utilisation.

It was a bit fiddly, but is something I can use each month now.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded