I have a sharepoint online date field named DueDate of type Date/Time that allow to enter Date Only (without time).
And i choice field named DueDatetime with these values:-
12:00 AM
12:30 AM
1:00 AM
1:30 AM
2:00 AM
2:30 AM
3:00 AM
3:30 AM
4:00 AM
4:30 AM
5:00 AM
5:30 AM
6:00 AM
6:30 AM
7:00 AM
7:30 AM
8:00 AM
8:30 AM
9:00 AM
9:30 AM
10:00 AM
10:30 AM
11:00 AM
11:30 AM
12:00 PM
12:30 PM
1:00 PM
1:30 PM
2:00 PM
2:30 PM
3:00 PM
3:30 PM
4:00 PM
4:30 PM
5:00 PM
5:30 PM
6:00 PM
6:30 PM
7:00 PM
7:30 PM
8:00 PM
8:30 PM
9:00 PM
9:30 PM
10:00 PM
10:30 PM
11:00 PM
11:30 PM
now i want to create a calculated column which will add the number of hours based on the choice selection to the due date, is this possible? i do not want to modify the DueDate field to allow Date and time, since i am using Search web parts and i need to control the time value, seems by default the time in search will be shown in UTC and not based on the site collection time zone... so can i created such as calculated column?
