Excel Formula Timesheet..?

Question

HELP! I have spent a few hours trying to figure this out. I would like to keep track of my own time, on excel. My hours are 3:00 p.m. w/ 30 min lunch I leave at 11:30 p.m. Can someone give me a simple formula that I can just copy and past on to my excel sheet. Thank you in advance... : )

Answer 1

= 23.5-15-.5

The key is to use army time. 23.5 hours (11:30 pm). If you subtract 23.5 from 15 hours (3:00 pm), and then subtract .5 (30 minute lunch) you will end up with 8 hours per day.

Day              Start    Lunch    End         Total

Monday          15       .5        23.5           8

Tuesday         15       .5        23.5           8

Wednesday    15       .5        23.5           8

Thursday        15       .5        23.5           8

Friday            15       .5        23.5           8

Answer 2

dun really get u...

u wanna keep track of every hour everyday from 3pm to 1130pm? or wat?

pls be more specific