Copper Contributor

The list is basically an holiday approval service, where a users can request leaving and his manager can approve or reject it. When the users set his start date is set correctly at 00.00 (12.00 AM). But on End_Date is always set on 00.00 (12.00 AM) and not on 23.59 (11.59 PM).

So if a users request leaving with this type of configuration


will be on holyday only the 7th of December, and not both days. 


How can i show, for End_Date, 23.59 and not 00.00?




2 Replies

@GiovanniB_ How are you setting time in date & time column?


For date and time column in our SharePoint online list, we have separate drop down to select the time: 

ganeshsanap_0-1701947629544.pngUnfortunately, no option available to select the 23:59 or 11:59PM as time entries are in interval of 30 minutes. You may need to customize the list form for your requirements. Check: Customize a Microsoft Lists or SharePoint form by using Power Apps 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.



Column typye is date

and i included hours.

I cant'do via powerapps because is disabled for most of the users of this sites