Results 1 to 8 of 8

Work time registration problem

Threaded View

  1. #1
    Registered User
    Join Date
    12-10-2014
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    13

    Work time registration problem

    Hello!

    I try to make a program that calculates my starting, ending and total workhour time. You can see my attachments. The first is when do I start at work. The next (slutt) is when I finish at work, and then it's pauses and total worked hours.
    But I want to make a program where I can punch whatever I want, and then Excel give me the answer on the last time.

    For example: If I want to work 12 hours one day, and I need 00:45 (45 minutes) brake (pause), and I need to leave 20:00, then Excel will give me the time I need to start at work in the A2. In this case 07:15.

    Other example: I want to start 07:30, and I need to work 14 hours with 1 hour pause, then the end-time should give me 22:30.


    Hope you understand what I mean. Is this possible with only using A2, B2, C2 and D2? Or do I need some help-calculating other places?

    Thanks!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 01-26-2014, 07:57 AM
  2. [SOLVED] Work Time Problem
    By pdizzy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2013, 12:17 PM
  3. Replies: 0
    Last Post: 11-12-2012, 04:49 AM
  4. Macros stop to work when work sheet is protected. Run time error 1004
    By sellim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2012, 01:14 AM
  5. [SOLVED] timesheet problem with making certain time values work.
    By shawnf711 in forum Excel General
    Replies: 4
    Last Post: 05-18-2012, 09:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1