Convert QuickBooks time format to excel to calculate

M

Misty May

When I export a Quickbooks "Time by Job Summary" report to Excel, the time is
converted in a time and date format. If I want to put a dollar amount to that
time, it needs to be converted into a number format. I can easily convert the
time for anything less than 24 hours using =(D18-INT(D18))*24. How can I
easily do that for any time greater than 24 hours?
 
P

Pete_UK

Give some examples of the type of data you want to convert. Are you
trying to get the date into one column and the time (in Excel format)
in another column, or are you saying that a time of say 5.5 days is
showing up as 12:00 5-Jan 1900?

Pete
 
M

Misty May

After exporting a QuickBooks Pro 2009 time summary sheet into Excel 2007 the
formulas in the Excel sheet shows as:

QuickBooks Excel shows as To convert to a number I use
Time shows as
0:30 12:30:00 AM =(D395-INT(D395))*24
24:30 1/1/1900 12:30:00 AM =(D399-INT(D399))*24)+24

I am looking for an easier solution to convert any time greater than 24
hours to a number value for additional billing purposes. Some time may be as
high as 145 hours.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top