I'm a relative novice at the use of more complicated formulas.

I'm trying to do a formula that would recognize 1= days and 2 =
nights, then insert the start time of either 06:00 for days or 18:00
for nights, depending entirely on the choice input by the user of the
spreadsheet. Additionally, I would like the spreadsheet to autofill
the balance with start/end times based on the required time for the
task assigned.

Any guidance would be greatly appreciated.

Jay