I clicked together an easy custom announcements list with Begin and End Date and wanted for each new item the following default values:
- Begin Date = TODAY
- End Date = TODAY + 1 hour
Setting the Begin Date is easy but I scratched my head a few times for the End Date. I found the following information about Formulas on Office Online so I went on experimenting.
Since you can only add DAYS, MONTHS or YEARS to a date I figured I'd add 1/24th of a DAY which is exactly 1 HOUR ;)
Here's what I thought to be the final solution: =TODAY+0.04167
Begin Date End Date
Unfortunately TODAY uses 12:00 AM as time offset, so you can only set it to "today at 1 AM" but not to "today in exactly 1 hour".
NOTE: When using this technique in a Calculated Field (eg =[BeginDate]+0.04167) this does work.
I'm not sure this can be achieved without using javascript or Custom Field Types.