Display Particular Value if Number is greater than or equal (#) and Number is Less than or equal (#)
I am creating a Spread sheet to keep track of my time sheets. I was wondering how to create a formula that will display a certain number if that number is greater than 4 and that same number is less than 7.
At my work Monday to Friday we are paid extras for Morning , Evening and Night Shifts
Morning Shifts must be starting from 4AM to 7AM
Day Shift Commences at or after 7AM and Finishes at or before 6PM
Evening Shifts Commence If you have worked At or past 6PM up until Midnight
Night Shifts Is if your shift finishes after midnight.
I want the TOTAL(DECIAML) value of hours to display in the particular category if it meets that particular shift criteria in Start and or finish.
E.g I would like 7.25 to display in Morning Of Monday as the Start time was before 4AM but no later than 7AM, But no other
I would like 6.50 to display in Morning of Tuesday as the Start time was before 4AM but no later than 7AM, But no other
I would like 5.75 to display in Afternoon of Wednesday as it satisfies finishing the shift after 6PM but no later than 12AM (00:00), But no other
Help Article Resources
Check out the Formula Handbook template!