+ Reply to Thread
Results 1 to 2 of 2

Minus break time minutes off working hours

  1. #1
    Registered User
    Join Date
    06-15-2014
    Posts
    1

    Minus break time minutes off working hours

    So basically I am trying to make a time calculator for work, I want it to automatically add the hours up but then also minus break times and then give me a whole paid total hours worked that week.

    I am very new at excel so please forgive me if this is easy.

    CALCULATOR.xlsx

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,602

    Re: Minus break time minutes off working hours

    What does 0.5 represent, half a day, half an hour? Why two different formats i.e. 0.5 & 30:00. Is 30:00 thirty minutes or 12:30 am?
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding Hours Worked minus lunch break IF over 5 hours
    By Gtrtim112 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-15-2013, 11:16 PM
  2. Total Working Hours Minus Break + Lunch Times
    By Rosco88 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2013, 05:01 AM
  3. Replies: 4
    Last Post: 02-12-2013, 07:01 AM
  4. Replies: 2
    Last Post: 02-11-2013, 02:26 PM
  5. [SOLVED] Date time calculations in minutes for working hours
    By jmac1947 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2012, 03:40 AM

Tags for this Thread

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