Excel Report for last 24 hours

I have a series of point that update every day at midnight. I am trying to export an excel report using the excel widget that only includes the values from this morning.
Which settings for the time period will give me those values?
I have tried past 24 hours, previous 24 hours, 11 pm yesterday to 8 am this morning, past 1 days, previous 1 days. None of those options give me the data I am looking for.
Any suggestions?

It sounds like what you want is the single cell data option. You can find this in the help documentation inside the Excel Reports Module:
This works by creating a named range such as "voltage" and then in your excel template give a single cell the named range of voltage.lastValue
Now link your voltage data point to the voltage named range.
From the help documentation:
Mango Data Available
Mango can insert various types of data into an Excel named range. Some are single cell while others require a column or row.
Single Cell Data
Single cell data can be assigned into cells by creating a named range with a .{data_name} postfix. For example to insert the XID for a data point one would use the named rangevoltage.average. Then via the Mango template configuration page one can link a data point to a named range of voltage. This will allow any named range that starts with voltage prefix to be filled in the the available single cell data. The following are a lists of available single cell data:
For any point:
xid  The XID of the linked point
name  The name of the linked point
deviceName  the device name of the linked pointFor Numeric Points:
firstValue  The first value of the time period
firstTime  The date of the first value of the time period
lastValue  The last value of the time period
lastTime  The date of the last value of the time period
minimumValue  The statistical minimum value of the time period
minimumTime  The date of the statistical minimum value of the time period
maximumValue  The statistical maximum value of the time period
maximumTime  The date of the statistical maximum value of the time period
average  The statistical average value of the time period
integral  The statistical integral value of the time period
sum  The statistical sum of the time period
count  The count of samples within the time periodSee more in the help documentation

I modified my named ranges to include only a single cell and tried to run the report again. This time I got this alarm:
This alarm is present for all named ranges and disappears if I include one more cell in the named range.
However when I do so I still cannot read the data from this morning.

I think you misunderstood the single cell ranges. You still need a multi cell rage for time stamps and all historical values.. You would then add a single cell range called point2.LastValue and you will get the last value for the data point associated with the names range point2