Convert QuickBooks time format to excel to calculate
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
On Feb 18, 5:14*pm, Misty May <Misty
wrote:
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?
|