PivotTable Calculated Field issue

M

michaelacumming

I'm new to working with calculated items in PivotTables, and I've run
into a bit of a snag.


My PivotTable is built off of a data set with a start and stop time (in

military time) for a number of workers. Included in the data set as
well is a worktype. I have a calculated field in my Pivot which returns

the # of hours worked by way of the following formula:


(EndTime-StartTime)*24


I have this data displayed by work type and date on the top, and by 1/2

hour interval of the start time on the left (the data set as well is
restricted to half hour intervals). This part works great!


For certain reasons, I need to subtract the hours worked within one
work type from the hours worked within another work type. This is where

I'm running into problems with a calculated item. For certain half hour

intervals, this works. However, for others, I'm getting wrong #'s, and
I can't even determine how Excel is calculating this. I think that it
has something to do with my formula above, as I am able to introduce
another column in my data set with a list of integers, and the
calculated item works great.


Any ideas? I'd be happy to share my file (or a screenshot), if that
would be helpful.


Thanks!


Michael Cumming
(e-mail address removed) , (e-mail address removed)
 

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

Top