•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Creating a work schedule visualiser
Hello!
I'd like to take a list of dynamic work shift times, 10:00-14:00, 12:00-18:00, etc, and paste them into column A of a sheet which will visually 'map out' the whole day with conditional formatting. The sheet columns would run from the beginning of the day, say 08:00, hourly, until the end of the day. A shift time of 08:00-12:00 pasted into column A would therefore fill in the cells from column 08:00 to column 12:00.
I'm certain this is possible but my research has turned up nothing but incorrect AI slop.
Excel version 2602
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#real-time data collaboration
#financial modeling with spreadsheets
#real-time collaboration
#Excel
#work schedule
#conditional formatting
#shift times
#visualiser
#time mapping
#dynamic
#daily schedule
#time slots
#day planning
#shift duration
#hourly
#work hours