I have a spread sheet that I keep the employees schedule in. What I'm trying
to do is let excel keep a tally of total hours for me.
A13 Has Carol B13 has 5:30-14:30 <~~ which are her hours for that day.
then C13, D13, E13, F13 etc etc has her schedule input the same way. (24
hour clock) In addition to keeping a tally of total hours, can it also
subtract 30 minutes per day for a lunch break?

I've tried all I know and nothing works.

Thanks in advance!