Format dropdowncell for quarter hour increments (as well as keeping half hour increments).

[Bassmike]

Hello. Using Excel 2007 to create timesheet invoice. Cell used for time is formatted to show hour and half hour as a dropdown option desired.eg 8:00 AM 8:30 AM.
How do I get it to show (format) the drop down options to show quarter hour increments as well? Or do I need to contact corporate? This is a template given to me years ago and now they calculate to nearest quarter hr. Redirect if addressed previously. Thanks much. M.

[FDibbins]

Hi, welcome to the forum

The DD is (probably) pulling from a named range or a list somewhere in that workbook. Find that list and adapt it to what you need - and dont forget to adjust the range for the DD (or the named range)

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.