Calculate time in a cell
Do the subtraction and then multiply by 24.
"TiaB" wrote in message
...
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!
|