Fanpages helped me with building out a array that identifies the relationship between Time/Date, Interval/Frequency and displays an end date and a number of data collection points. Due to the application of this spreadsheet, I need to have a macro that can fire to change the Time/Date Format that is in the WB now, to a more granular view. So, by firing the macro, I need the date formats to change from Time/Date (Mo./Day/Yr., Hr., Min. Sec.) ((THIS IS THE CURRENT FORMAT), to Date: Yr. (e.g. 2013, 2014, 2015), Date: Mo. Yr. (e.g. 04/2013, 05/2015, etc.), Time: Day (e.g. Mon, Tues, etc.), Time: Hr./Min. (e.g. 03:35, 14:28, Time: Hr./Min./Sec.). To be able to see the status in the button or to the side would be nice.
Thank you in advance,