If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating Resolution Rates
I'm trying to calculate resolution rates from our help ticketing system in
Excel - I've tried several recommendations from here and they're not counting total hours (if the range is more than 1 day, it's not adding the additional 24 hours). My Dates are formatted like this: Column A: 2/4/10 9:25 Column B: 3/15/10 14:07 The formatting for these cells is: Date 3/14/01 13:30 The result of a simple B1-A1 is coming out to: 4:42 The formatting for this cell is: Custom h:mm I'm hoping someone can provide me with some suggestions, it would be much appreciated! Thanks - Rhonda |
#2
|
|||
|
|||
Calculating Resolution Rates
Hi,
the format hh:mm rolls over to zero after 24 hours so use [h]:mm and it won't roll over -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Rhonda Urbanczyk" wrote: I'm trying to calculate resolution rates from our help ticketing system in Excel - I've tried several recommendations from here and they're not counting total hours (if the range is more than 1 day, it's not adding the additional 24 hours). My Dates are formatted like this: Column A: 2/4/10 9:25 Column B: 3/15/10 14:07 The formatting for these cells is: Date 3/14/01 13:30 The result of a simple B1-A1 is coming out to: 4:42 The formatting for this cell is: Custom h:mm I'm hoping someone can provide me with some suggestions, it would be much appreciated! Thanks - Rhonda |
#3
|
|||
|
|||
Calculating Resolution Rates
Try [h]:mm
-- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Rhonda Urbanczyk" wrote: I'm trying to calculate resolution rates from our help ticketing system in Excel - I've tried several recommendations from here and they're not counting total hours (if the range is more than 1 day, it's not adding the additional 24 hours). My Dates are formatted like this: Column A: 2/4/10 9:25 Column B: 3/15/10 14:07 The formatting for these cells is: Date 3/14/01 13:30 The result of a simple B1-A1 is coming out to: 4:42 The formatting for this cell is: Custom h:mm I'm hoping someone can provide me with some suggestions, it would be much appreciated! Thanks - Rhonda |
#4
|
|||
|
|||
Calculating Resolution Rates
You haven't said which recommendations from here you've tried, but try
changing h:mm to [h]:mm -- David Biddulph "Rhonda Urbanczyk" Rhonda wrote in message ... I'm trying to calculate resolution rates from our help ticketing system in Excel - I've tried several recommendations from here and they're not counting total hours (if the range is more than 1 day, it's not adding the additional 24 hours). My Dates are formatted like this: Column A: 2/4/10 9:25 Column B: 3/15/10 14:07 The formatting for these cells is: Date 3/14/01 13:30 The result of a simple B1-A1 is coming out to: 4:42 The formatting for this cell is: Custom h:mm I'm hoping someone can provide me with some suggestions, it would be much appreciated! Thanks - Rhonda |
#5
|
|||
|
|||
Calculating Resolution Rates
Thank you both so much, perfect!
|
Thread Tools | |
Display Modes | |
|
|