How To Create A Time Off Report To Reflect Half Days vs. Full Days

Question

Is there a way to pull future PTO/time requested off hours (or somehow add in via text mode) where you can distinguish full days vs. partial days into a report? [For example] Our team wants to be able to easily see who is requesting full days off vs. who is requesting 4 hours in that day off. Thanks!

William-- · Accepted Answer

There's probably a neater way that could enable conditional formatting or filtering, but in a pinch this column in your Time Off report will show the duration of time in Hours if less than 8 hours, or in Days if more than 8 hours.

displayname=Duration
textmode=true
valueexpression=IF((DATEDIFF({startDate},{endDate})*-1)<.3333,CONCAT((DATEDIFF({startDate},{endDate})*-1*24)," Hours"),CONCAT(ROUND((DATEDIFF({startDate},{endDate})*-1),0)," Days"))
valueformat=HTML

Stacey_Robertson · Answer

We use a custom form with a drop down for Partial or Full Days off.  We don't use the built in Time Off Calendar because we need to have days off approved so we have a request queue for PTO.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded