How do I create an if statement based on RTC time?

It depents on the library you use to use the RTC. If you use the RTClib you can just do:

#include <Wire.h>
#include "RTClib.h"

RTC_DS1307 rtc;

void setup () {
  Wire.begin();
  rtc.begin();
}

void loop () {
    DateTime now = rtc.now();
   
   if(now.hour() == 6 && now.minutes() == 00){
     //do something
   }
}

Be aware it i called the WHOLE minute long. If you don't want that you need to save the state as well.