So, obviously Excel is not my forte.
I'm still working on my timesheet, and have run into a new and exciting problem.
The timesheet has these columns:
Time In
Time out for lunch
Time in from lunch
Time Out
Then, it calculates the hours worked using this formula:
=((F10-C10+(F10<C10))-(E10-D10+(E10<D10)))*24
Works great. BUT, ran into a weird problem last night that I can't figure out.
Yesterday, I worked from 8:00 am to 12:00 am (midnight) last night. When I enter these as my times in and out, the formula calculates and displays just fine -- but the 12:00 am does NOT display in the Time Out column. I see it in the formula bar, and it obviously is there because the formula is calculating correctly. I tested other times, and all others display...but 12:00 am does not.
I've checked conditional formatting, but there's nothing there.
What am I missing????
MUCH thanks,
Julia
I'm still working on my timesheet, and have run into a new and exciting problem.
The timesheet has these columns:
Time In
Time out for lunch
Time in from lunch
Time Out
Then, it calculates the hours worked using this formula:
=((F10-C10+(F10<C10))-(E10-D10+(E10<D10)))*24
Works great. BUT, ran into a weird problem last night that I can't figure out.
Yesterday, I worked from 8:00 am to 12:00 am (midnight) last night. When I enter these as my times in and out, the formula calculates and displays just fine -- but the 12:00 am does NOT display in the Time Out column. I see it in the formula bar, and it obviously is there because the formula is calculating correctly. I tested other times, and all others display...but 12:00 am does not.
I've checked conditional formatting, but there's nothing there.
What am I missing????
MUCH thanks,
Julia