+ Reply to Thread
Results 1 to 14 of 14

calculating time

Hybrid View

  1. 07-04-2013, 03:03 PM #1
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: calculating time

    Hi djmatok..

    Please check the updated file..

    excelforum tally hours.xlsx
    It demostate.. to check if a day is weekday or not...

    Formula used..


    Formula: copy to clipboard 
    =WEEKDAY(C9)

    Formula: copy to clipboard 
    =TEXT(C9,"dddd")

    &
    Formula: copy to clipboard 
    =IF(WEEKDAY(C9,2)>5,"It’s a WeekEnd","Weekday")


    You can use any of the above for your next step..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...
    Reply With QuoteRegister To Reply
  2. 07-04-2013, 03:09 PM #2
    djmatok
    djmatok is offline
    Forum Contributor
    Join Date
    06-27-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    164

    Re: calculating time

    got it. I will use the 2nd formula provided. sorry for that
    Reply With QuoteRegister To Reply
  3. 07-04-2013, 03:11 PM #3
    djmatok
    djmatok is offline
    Forum Contributor
    Join Date
    06-27-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    164

    Re: calculating time

    I want to show at the top :
    actual hours - fixed hours = excess hours

    excess hours * rate = billable hours/USD
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1