I’m working on a spreadsheet which would automatically calculate the amount of night hours worked.
Night hours are calculated militarily from 22:00 until 6:00 in the morning. It’s a spreadsheet which other people are using, so I’d like “6:00” to be inputted as such and not “30:00” even if it’s finally formatted as “6:00”.
The example result I’d like to achieve is:
The problem I’m having is how to qualify the night hours.
Thanks in advance for any pointers,