サインイン
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
customize my timesheet print pwa 2007

Answered customize my timesheet print pwa 2007

  • 2010年5月17日 19:20
     
     
    サインインして投票
    0

    I am looking how to customize my timesheet print. Or may an excel cube link to signed in user for current week. I need to sum the week, add hard copy signature lines. Big TIA!

     

    -JS

     

すべての返信

  • 2010年5月18日 2:43
    モデレータ
     
     回答済み
    サインインして投票
    0

    Hi,

    Out of the box there isn't really a simple way of adding a signature line etc. I would consider maybe using the Export to Excel option and then writing a macro in Excel that would format the output and add the desired branding and hard copy signature lines?

    Hope this is of use.

     

    alex.

    Alex Burton www.epmsource.com
     
  • 2010年5月18日 21:14
     
     
    サインインして投票
    0

    Thankx for the reply, I was leaning that way. I have most of it completed. Are you good with excel? If so, what would you do to sum the "Total" row?. I have the last row, but can't sum 4h,8h,8h, etc. TIA!

    -JS

     
  • 2010年5月18日 22:41
    モデレータ
     
     
    サインインして投票
    0

    Sorry Excel isn't my thing, but I would imagine you could remove the 'h' from the string and use Excel's out of the box summing capabilities? 

    I might have a play with it and write a blog post covering it in the next few weeks. 

    Alex. 

    Alex Burton www.epmsource.com
     
  • 2010年5月19日 13:14
    モデレータ
     
     回答済み
    サインインして投票
    0
    The Excel formula would look something like this:
     
    =VALUE(LEFT(A1,LEN(A1)-2))
     
    Where A1 = the cell from the timesheet.
     
    That'll convert a text entry of "4 h" to a numerical entry of "4".
     
    - Andrew Lavinsky
    Blog: http://blogs.catapultsystems.com/epm
     
     
     
     
  • 2010年5月19日 16:13
     
     
    サインインして投票
    0

    Thankx for the help. I can write the formula. If you export the timesheet to excel you'll see the last row has the day totals. I find the last row and want to total the week hours in this cell with a macro:

    Cells(Rows.Count, "B").End(xlUp).Offset(0, 1).Value =

    Clear as mud?

    -JS

     

     
  • 2010年5月20日 7:01
    モデレータ
     
     回答済み
    サインインして投票
    0

    Hi JS,

    does this formula help? SUMPRODUCT(SUBSTITUTE(A1:C1;"h";"")*1)
    A1:C1 has to be replaced, of course ;-)

    Regards
    Barbara