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

[wesleyanne]

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 solution]

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

[wesleyanne]

Worked like a charm! Thank you!

[Stacey_Robertson]

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.

[wesleyanne]

Thank you for this suggestion, great idea.