How do I add a time to a cell based on a value in another column

Ok let's make this easy it's hard to explain, at least for me

So I deleted all my times in column C.........I have to add them back in

Is there a way to automatically do this?

For example: When column H says "MIDNIGHT CLOSE" there should be a time of 24:00 in column C
When column H says "MIDNIGHT OPEN" there should be a time of 0:00 in Column C

Is there a way I can populate this without manually typing it in?

Thanks you guys are the best

I filled in the 1/1/2024 day and 1/2/2024 day to show what it's supposed to look like

Very simple.
Filter your table, select the column cells, fill the first one then [Crtl]+[Enter].

Originally Posted by TMS

Turn on AutoFilter. Filter on Midnight Close. Drag an existing time down. Or type it in the first cell and drag it down. Clear the filter. Repeat for Midnight Open. Turn off the AutoFilter.

this works nice I tried to give you reputation but it didn't let me for some reason I can't give two people reputation on the same post

oh it worked..........this takes the workload down a lot thanks