M
mikex30
I have a sheet for my time at work. I want to subtract time for lunch.
Col B is "In" to work Col C is "Out" finished work. Everything is on 24
hr clock, no am or pm. I would like a col D "Lunch" in minutes or
fractions of hour.
B is 0800 arrive at work
C is 1700 leave for the day.
D is 0.50 for lunch
E is 8.5 hours worked
Again I want everything to be on 24 hour clock.
I copied this formula from a template. =(C8-B8+(C8<B8))*24
The templates I found all had out/in for lunch. I just want one col
with the time spent at lunch.
M
Col B is "In" to work Col C is "Out" finished work. Everything is on 24
hr clock, no am or pm. I would like a col D "Lunch" in minutes or
fractions of hour.
B is 0800 arrive at work
C is 1700 leave for the day.
D is 0.50 for lunch
E is 8.5 hours worked
Again I want everything to be on 24 hour clock.
I copied this formula from a template. =(C8-B8+(C8<B8))*24
The templates I found all had out/in for lunch. I just want one col
with the time spent at lunch.
M