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?
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?