+ Reply to Thread
Results 1 to 4 of 4

Timesheet help

  1. #1
    kimmyrt
    Guest

    Timesheet help

    I have a timesheet where I keep a running total of the overtime. This is an
    example of the formula:
    =IF($K46="","",REPT("
    ",4-SEARCH(":",TEXT($K46,"[h]:mm")))&TEXT($K46,"[h]:mm")&REPT("
    ",4-1-(LEN(TEXT($K46,"[h]:mm"))-SEARCH(":",TEXT($K46,"[h]:mm")))))
    Now this is my problem, I need to subtract just 8 hrs. from that and have it
    continue every week with the new total. Everything I've tried gives me
    errors. So I was wondering if anyone knew what to do. If you would like to
    see the timesheet I can send it to you because you may need to see it to
    understand what I'm saying. I'm not very good at explaining Anyway,
    thanks for any help!

  2. #2
    Biff
    Guest

    Timesheet help

    Hi!

    I love timesheets!

    Post a good email address and I'll contact you.

    Biff

    >-----Original Message-----
    >I have a timesheet where I keep a running total of the

    overtime. This is an
    >example of the formula:
    >=IF($K46="","",REPT("
    >",4-SEARCH(":",TEXT($K46,"[h]:mm")))&TEXT($K46,"[h]:mm")

    &REPT("
    >",4-1-(LEN(TEXT($K46,"[h]:mm"))-SEARCH(":",TEXT

    ($K46,"[h]:mm")))))
    >Now this is my problem, I need to subtract just 8 hrs.

    from that and have it
    >continue every week with the new total. Everything I've

    tried gives me
    >errors. So I was wondering if anyone knew what to do.

    If you would like to
    >see the timesheet I can send it to you because you may

    need to see it to
    >understand what I'm saying. I'm not very good at

    explaining Anyway,
    >thanks for any help!
    >.
    >


  3. #3
    veronic633@yahoo.com
    Guest

    Re: Timesheet help


    hey biff, I think you were the one who helped me create this timesheet
    in the first place! I was trying to get a hold of you but I lost your
    e-mail address. Mine is veronic633@yahoo.com just let me know what
    yours is and I'll send you the timesheet with a detailed explanation.
    Thanks


  4. #4
    Biff
    Guest

    Re: Timesheet help

    Ok, sent you an email.

    Biff

    >-----Original Message-----
    >
    >hey biff, I think you were the one who helped me create

    this timesheet
    >in the first place! I was trying to get a hold of you

    but I lost your
    >e-mail address. Mine is veronic633@yahoo.com just let

    me know what
    >yours is and I'll send you the timesheet with a detailed

    explanation.
    >Thanks
    >
    >.
    >


+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1