# Timesheet help

1. ## 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. ## 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. ## 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. ## 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
>
>.
>

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

#### 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