•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to figure out how to calculate hours on a schedule using excel
Hi I’m trying to work on a schedule and have everyone listed as like ANON 9-5 or 9-4 in a chart and I’m trying to figure out how to set excel to calculate that “9-5” is an 8 hr shift and put it off to the side of the calendar so I can keep track of hours used without doing it by hand. I looked into conditional formatting but it just keeps trying to change the colors of the cells instead of calculating anything for me. Any help is appreciated thanks!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#schedule
#excel
#hours
#calculate
#shift
#conditional formatting
#chart
#calendar
#work hours
#tracking
#automation
#user input
#formula
#time management