Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

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

Avatar

Level 2

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! 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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



If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

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



If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf

Avatar

Level 6

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.