J
jrt
Hi,
I have a spreadsheet to track staff who work holidays/overtime hrs.
A B C D
HOLIDAY Start Time End Time Pay
1 New Yr Eve 8:00 PM 12:00 AM Overtime
2 New Yr Day 12:00 AM 7:00 AM Regular time
So for any holiday that is an "Eve" I want to force the end time to be 12:00
AM since the pay is overtime up until 11:59PM. I created another field to
force the 12:00 AM time into the End Time field that logically seems to make
sense but is not calculating correctly...
=IF(A1="New Yr Eve", C1=12:00 AM, " ")
End Time is currently a drop down list with values 12:00AM - 11:59PM.
Thank you.
I have a spreadsheet to track staff who work holidays/overtime hrs.
A B C D
HOLIDAY Start Time End Time Pay
1 New Yr Eve 8:00 PM 12:00 AM Overtime
2 New Yr Day 12:00 AM 7:00 AM Regular time
So for any holiday that is an "Eve" I want to force the end time to be 12:00
AM since the pay is overtime up until 11:59PM. I created another field to
force the 12:00 AM time into the End Time field that logically seems to make
sense but is not calculating correctly...
=IF(A1="New Yr Eve", C1=12:00 AM, " ")
End Time is currently a drop down list with values 12:00AM - 11:59PM.
Thank you.