Expand my Community achievements bar.

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.