Excel Formula for Scheduling Calculations

New Contributor

I am working on creating a work schedule for our agency using Excel.  I need to figure out how to assign a numeric value to letters (A=12hour shift) and how to assign a numeric value to another number (1=8hour shift).  it would also be nice to figure out how hours can be totaled if  military time elements are entered into a specific day (Ex:  employee works from 0700-1500 on a specific day;  distinguish those hours and calculate the sum for the week).  any suggestions?



3 Replies
You need to attach your sample file with the data and results you want to achieve.

sorry, I am not willing to post my agency's work schedule online anywhere@Twifoo 

I was asking for the sample file, not the actual file.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies