Question
I need the calendar to add up the hours worked for each day, and subtract 1 hour each day for lunch automatically. Below is the
I need the calendar to add up the hours worked for each day, and subtract 1 hour each day for lunch automatically. Below is the code that I have used for the Excel function, but it needs to be fixed to take a hour out for each day for lunch. Right now it is adding up the hours fine but I can not figure out how to subtract an hour for lunch each day. If someone knows, can you please help me to figure this out. Thanks, in advance.
Here is a link to the file: https://drive.google.com/file/d/121i-3DQ30Zs_UHI4w1QPak8WaQk7_qb0/view?usp=sharing
Code: =IF(((D5-C5)+(F5-E5)+(H5-G5)+(J5-I5)+(L5-K5)+(N5-M5))*24>40,40,((D5-C5)+(F5-E5)+(H5-G5)+(J5-I5)+(L5-K5)+(N5-M5))*24)
Table Tools hedule (version 1) - Excel Home Insert Draw Page Layout Formulas Data Review View Developer Help Design Tell me what you want to do Spelling Thesaurus Chc Smar Translate New Delete Previous Next Show Notes Protect Protect Allow Edit Unshare Hide Sheet Workbook Ranges Workbook Ink Accessibilty Lookup Comment Comment Comments Acesiblitly Inihts oust k 05 F(((D5C5 4(FS E5) (H5 G5) (15 5) (L5-5) (N5 MAS)) 24 40,40 ((DS-C5) (F5-ES)+p 5-G5)5-15)4(5-5)(N55)) 24) Weeilvy Work Schedule Our Family Serving Your Family Since 1956 Tue Wed Thu Fri Sat 2/18/2019 2/19/2019 2/20/2019 2/21/2019 2/22/2019 2/23/2019 Out In Out In Out In Out In Out In Out Reg. . 9:00 AM 5:00 PM 9:00 AM 5:00 PM 16.00 12 13 Total 16.00 16 17 18 20 21 Weekly Work Schedule Backup Table Tools hedule (version 1) - Excel Home Insert Draw Page Layout Formulas Data Review View Developer Help Design Tell me what you want to do Spelling Thesaurus Chc Smar Translate New Delete Previous Next Show Notes Protect Protect Allow Edit Unshare Hide Sheet Workbook Ranges Workbook Ink Accessibilty Lookup Comment Comment Comments Acesiblitly Inihts oust k 05 F(((D5C5 4(FS E5) (H5 G5) (15 5) (L5-5) (N5 MAS)) 24 40,40 ((DS-C5) (F5-ES)+p 5-G5)5-15)4(5-5)(N55)) 24) Weeilvy Work Schedule Our Family Serving Your Family Since 1956 Tue Wed Thu Fri Sat 2/18/2019 2/19/2019 2/20/2019 2/21/2019 2/22/2019 2/23/2019 Out In Out In Out In Out In Out In Out Reg. . 9:00 AM 5:00 PM 9:00 AM 5:00 PM 16.00 12 13 Total 16.00 16 17 18 20 21 Weekly Work Schedule Backup
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started