|
#1
|
|||
|
|||
Timesheets to Invoices - Time being imported as days
I've a spreadsheet that links to personnel timesheets and calculates total time worked in a given period, this then shows pay due based on their hourly rate.
I'm now trying to complete a mail merge in Windows so that I can produce basic payslips/invoices for the self employed workers which will show their total hours. The problem I have is that what will show as 26:00 (26 hours) in Excel is showing as 1.0833343333 in the mail merge field within Word. I can get around the amount of decimal points by adding \# "0.00" to format the field but cannot seem to find how to retain 26:00 as desired. There is a fair amount of formatting and formulas within the spreadsheet already so I'm trying not to change anything there if possible. Any tips would be gratefully received! |
#2
|
||||
|
||||
See Mailmerge Data Format Problems in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
number for invoices and forms automatically increasing by 1 each time I open the template | Fedjwick | Excel | 3 | 05-01-2017 05:38 AM |
Multiple Timesheets - id'ing two people working on the same machine at the same time. | Will | Excel | 1 | 09-28-2016 09:12 AM |
Calculating Average Time across days | lizakay | Excel | 3 | 11-25-2015 05:16 PM |
Calculate Average Time Elapsed in Days, hours and minutes | Nina46 | Excel | 9 | 09-11-2015 02:09 AM |
infopath for timesheets & project management | eekoh | Misc | 0 | 02-24-2015 07:57 AM |