1

I realise I'm probably splitting hairs here, but I feel like there should be some sort of convention or best practice for this situation, but I haven't been able to find anything online, and I can't figure out what it should be.

I'm developing a rostering tool which produces a weekly calendar. The majority of the work assignments are for an entire week, so having a single cell to indicate that is both sufficient, and desirable from an information-density standpoint.

That being said, occasionally someone will be assigned somewhere for only part of a week, and it is necessary for this to be indicated on the calendar. The obvious solution is to simply include the days of the week in the cell, when it's a partial week assignment - for example, if the person is only working Monday to Thursday, it might say (M-Th), if they were working Monday, Wednesday & Friday, it'd say (M,W,F), if they were working every day except Thursday, it'd say (M-W,F), and so on.

The issue is how to deal with two-day work periods - if, for example, they're working on Monday and Tuesday, should it be (M,Tu) or (M-Tu)?

I can see arguments for both sides - on the one hand, the dash can be taken to indicate the elision of days for the sake of brevity (e.g. in the case "M-Th", where the dash takes the place of "Tu" and "W"); in which case, it should be "M,Tu", as there are no days between Monday and Tuesday that are being elided from the text.

On the other hand, the dash could be interpreted as an indication that the period being specified is continuous run of days, (i.e. "M-Th" indicates there are no gaps between M and Th) in which case it should be "M-Tu", as there is no gap between Monday and Tuesday.

Is there a standard for this? Is there something I've missed?

2

As I understand your issue it most definitely should be Mon-Tue (or M-Tu to use your formatting) because it indicates a continuity of the assignment. They're not just there Monday and on Tuesday, they are working there from Monday and shall not be finished with the assignment until Tuesday.

I would support "M,Tu" if a worker simply had two meetings that would take them to that location once each day but if it's a work assignment it's the continuity of that placement that's key. It's akin to why the transporter in Star Trek is murder: breaking of continuity of consciousness, even for a minute, is murder much like the errant comma here would imply two separate, albeit close, assignments rather than one that lasts two days.

I'm very prepared to die on this hill (or metaphorical star ship)

  • Whilst I 100% agree with you with regards to the transporter, it is worth noting that their workdays on Monday and Tuesday are separate - i.e. they do get to go home at the end of the day; we're not running a Dickensian Workhouse... – LoquaciousDandy May 16 '18 at 8:28
  • 1
    Sure, but presumably Monday and Tuesday's work are related. I assumed they were allowed to leave. – 2vix May 16 '18 at 10:10
  • Although, consider how efficient a database would be if you were running a Dickensian workhouse. No automation needed as you know they're working, eating and sleeping in the same place every day. You'd need to automate removing them from the warehouse when they die though I guess... – 2vix May 16 '18 at 10:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.