Hi Richard ,
the time formula in excel works are follows =time(hh,mm,ss) . This returns the a composite value that shows time. I was wondering if there is such a function in Access . This is the function from the excel sheet that I am trying to convert to access format but it does not work since time function in access is different

=IF(AND(C2>=TIME(HOUR(C2),0,0),$C$2<=TIME((HOUR(C2)),30,0)),(HOUR(C2)&":00-")&(HOUR(C2)&":30"),(HOUR(C2)&":30-")&(HOUR(C2)+1&":00"))