I am trying to make a spreadsheet to make work schedules. What I would like to do is take a time from one field, plus a time from a second field then display the two in a third field separated by a "-" without the hyphen being a subtraction calculation.
For example: Cell A5 contains 8:00, Cell A6 contains 14:00, Now I would like to display "8:00-14:00" in another cell.
The reason is to have a schedule for workers from Sunday to Saturday showing the hours that they are scheduled for.
I am already using Start and Stop times elsewhere in the spreadsheet...would just like to pull them together for printing.
The "*" below are to separate the data for illustration purposes in this thread, but are not represented in the spreadsheet.
**********Sun*********Mon
Mike****8:00-10:00***10:00-15:00
Ray****9:00-16:00******etc
John***12:00-17:00******etc
Is this possible?
Bookmarks