Skip to main content
L
louann3
October 7, 2021
Question

Export to excel - duration format HELP!

  • October 7, 2021
  • 3 replies
  • 0 views

Please help!   I export reports each week to pull hours (duration) by employee.   the duration column has ALWAYS been formatted as a decimal (40.00) so they can be added up, averaged, etc.   Today, as I'm trying to pull my reports in, the duration column is coming in as TEXT (40:00) which I can't use formulas with. Please help!  I have tons of reports that I do every Thursday night and now I'm freaking out!

Attached a file to show the difference. I need it back to the old format for formulas to work!

3 replies

M
MirriamM
October 7, 2021

Thanks for reaching out to us, @louann3.

 

Allow me to share information with you about running reports in QuickBooks Online (QBO).

 

When pulling a report for the Time Activities of your Employees, the Duration information is formatted as Time Hours (40:00). 

 

If you want to have the time converted into the number of hours, you can export the report to excel. Then, multiply the time by 24 hours, and you'll want to make sure it's formatted to a decimal number.

 

For more information about running reports, see below links which you may find helpful:

 

If you have specific questions, please let me know. I will be more than happy to further assist you. Have a nice day.

L
louann3Author
October 8, 2021

Thank you for the work around.   Up until Wed, I would export the Time Activities report to excel and the duration column showed decimals and not  hours.  Frustrating that it changed.  :(

S
Smile74
October 13, 2021

Time Format is NOT HELPFUL when processes have been built on the time being exported as a DECIMAL until now. There should be at least an option to select formatting requirements, not change this drastically without notice! 

Fiat Lux - ASIA
Fiat Lux - ASIA
October 13, 2021

@Smile74 @louann3 

Explore an exporter tool as a workaround.

https://transactionpro.grsm.io/qbo

 

F
frustrateduser2
October 13, 2021

CAN QUICKBOOKS JUST PLEASE REVERT BACK TO THE OLD DECIMAL SYSTEM!!! .25, .50 and .75 instead of .15, .30 and .45!!  We should not have to do work arounds because suddenly someone in intuit decided this was their preferred option!! The original post- is not alone in needing to run reports in excel!  Because INTUIT does not meet all of our needs!! 

    S
    Smile74
    October 13, 2021

    Dear ALL Frustrated users,

    After spending an hour with a QB Support Rep (very genuine, professional, supportive), investigating WHAT WE CAN DO at this point...is to POST 'FEEDBACK' in the QB App (top right corner). QB Developers read these and make updates accordingly 2x monthly based on the feedback shared.

    I can account for at least 5 users of my team whom have logged this complaint as 'feedback' just today. PLEASE SPREAD THE WORD so this can be resolved sooner than later.

     

    Thanks for your post.

    F
    frustrateduser2
    October 13, 2021

    I will be posting "feedback" in all my clients books and have my boss do the same. This is a ridiculous change! 

    Thank you Smile 74 for taking so much time on this! I know it can be a time suck calling in!  

    Terms & ConditionsAccessibility statement