Negative time numbers

J

JT

I import data from QuickBooks on how much time it takes to do an activity.
The data comes into Excel fine. I know want to compare that data to budgeted
time. For example I budgeted 84 hours to get something done and it actually
took 96 hours (that's the number from Quickbooks). How can I get Excel to
show a negative 12 hours?
 
F

Fred Smith

Excel will calculate negative times, it just won't display them. So convert
your answer to decimal hours by multiplying by 24, then display as a number.

Regards,
Fred.
 
J

John C

Well, in the General Questions section, Fred said to look at his answer to
your question in the Worksheet Functions section. I will return the favor,
you should look at my answer to your question in the General Questions
section. I give you a workaround.
 

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

Similar Threads

Convert QuickBooks time format to excel to calculate 2
Time Calculation to showing negative value? 2
Adding a negative number instead of substracting it 3
negative time summation calculation for a standard day 2
Negative time calculations 9
IF Logic Function with negative time or early time 1
Show time as a negative figure 3
negative time in Hours and mins 2

Top