Solved

# subtract totalled time from a given number of hours - Excel

Posted on 2014-10-01

so here's my scenario

I've got a list of parts and for each part I need to track time used on them. So far so good. I have then set up a sumifs formula which totals the time used for each part. So far so good.

Now what I want to do is subtract this total time used from a given number of hours so that it shows me the number of hours left for this part. So for the example below. My given number of hours is 2000. My hours used to date is 4:49:00 - and according to this formula where Calculations!B3 has the 2000 in it (General format)

=components[@[lifetime (hours)]]-(Calculations!B3*24)

my hours left are 04:24:00 - which isn't correct obviously

I've tried this:

=components[@[lifetime (hours)]]-(Calculations!B3)

and got 19:11:00 for my hours left which isn't right either.

So what am I missing here?? Thank you :-)