Hello,
Need some help trying to figure out why when I create a heat map from different timeframes that I'm only getting ":00" and ":30" and not 8:00am, 8:30am, 9:00am, 9:30am...etc. I'm using the formula =FLOOR(N2,"0:30") to round the timeframe to the half hour. I'm sure using "0:30" is...