Jump to content

  • Log In with Google      Sign In   
  • Create Account


Urgent help in Excel required...


Old topic!
Guest, the last post of this topic is over 60 days old and at this point you may not reply in this topic. If you wish to continue this conversation start a new topic.

  • You cannot reply to this topic
1 reply to this topic

#1 Zultra   Members   -  Reputation: 101

Like
0Likes
Like

Posted 13 July 2013 - 01:58 AM

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.



Sponsor:

#2 Brother Bob   Moderators   -  Reputation: 7863

Like
0Likes
Like

Posted 13 July 2013 - 03:53 AM

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






Old topic!
Guest, the last post of this topic is over 60 days old and at this point you may not reply in this topic. If you wish to continue this conversation start a new topic.



PARTNERS