Microsoft Office Forums Timesheets to Invoices - Time being imported as days

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-30-2019, 09:27 AM
dave6084 dave6084 is offline Timesheets to Invoices - Time being imported as days Windows 10 Timesheets to Invoices - Time being imported as days Office 2016
Novice
Timesheets to Invoices - Time being imported as days
 
Join Date: Oct 2019
Posts: 1
dave6084 is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 11-02-2019, 11:01 PM
macropod's Avatar
macropod macropod is online now Timesheets to Invoices - Time being imported as days Windows 7 64bit Timesheets to Invoices - Time being imported as days Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,671
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Timesheets to Invoices - Time being imported as days 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
Timesheets to Invoices - Time being imported as days 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


All times are GMT -7. The time now is 03:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft