I'll try to explain. I have two columns of military time (FROMTIME and TOTIME)
I have other columns within the same sheet titled 0000-0059, 0100-0159, 0200-0259, etc.
What I need to do is based on the FROMTIME and TOTIME is to place an X in the appropriate columns.
For example, if the FROMTIME is 1045 and the TOTIME is 1200, I need an X placed in the 1000-1059 column and the 1100-1159 column (not the 1200-1259 column, because the incident didn't potentially happen during that "hour span" - that's a management thing, long story).
Also, if an incident occurrs from 2300-0145, I need to be able to put the x in the last column (2300-2359) and the first column (0000-0059).
Is this do-able or is it another "can you total this diagonally for me?" type question?
I have other columns within the same sheet titled 0000-0059, 0100-0159, 0200-0259, etc.
What I need to do is based on the FROMTIME and TOTIME is to place an X in the appropriate columns.
For example, if the FROMTIME is 1045 and the TOTIME is 1200, I need an X placed in the 1000-1059 column and the 1100-1159 column (not the 1200-1259 column, because the incident didn't potentially happen during that "hour span" - that's a management thing, long story).
Also, if an incident occurrs from 2300-0145, I need to be able to put the x in the last column (2300-2359) and the first column (0000-0059).
Is this do-able or is it another "can you total this diagonally for me?" type question?