Urgent help in Excel required...

Started by
0 comments, last by Brother Bob 10 years, 9 months ago

I want to do a sort of work table showing the time I started and the time I finished with a 30 min break in the middle for example, which then calculates the total time worked next to it taking away break time, I'm a novice.

Here is a example.

This is in time;

Start Lunch End Time spent working (hours)
09:30 13:00 15:00 Time goes here.

Advertisement

End time minus start time, and then subtract 1/48 representing the half hour break (1/48 for a day).

This topic is closed to new replies.

Advertisement