J
jfm
I am trying to build a formula or function that will split
a start and stop time into time categories. For example,
the three time categories would be 12:00 midnight -
7:00am, 7:01am - 5:00pm, and 5:01pm - 11:59pm. If a
surgery started at 3:00am and ended at 9:00am, the formula
or function would return 4 hours for the category 12:00
midnight to 7:00am and 2 hour for the category 7:01am to
5:00pm. Would anyone have advice on grouping times by
category? Any help is appreciated.
a start and stop time into time categories. For example,
the three time categories would be 12:00 midnight -
7:00am, 7:01am - 5:00pm, and 5:01pm - 11:59pm. If a
surgery started at 3:00am and ended at 9:00am, the formula
or function would return 4 hours for the category 12:00
midnight to 7:00am and 2 hour for the category 7:01am to
5:00pm. Would anyone have advice on grouping times by
category? Any help is appreciated.