Change the time so the date changes @6am

is there any way to make the date change at 06 am rather than 12 midnight, so that the date change would coincide with a shift change
cronic

Try

=INT(NOW()-"06:00")

format as date

Thanks for taking the time to answer daddylonglegs