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!
Solved! Go to Solution.
Views
Replies
Total Likes
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
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
Worked like a charm! Thank you!
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.
Thank you for this suggestion, great idea.
Views
Replies
Total Likes
Views
Likes
Replies