Prev: Indirect and Sheet Name
Next: VLookup with Search for in String
From: Rhonda Urbanczyk Rhonda on 23 Mar 2010 18:11
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

From: Mike H on 23 Mar 2010 18:21
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
>
From: Russell Dawson on 23 Mar 2010 18:22
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
>
From: "David Biddulph" groups [at] on 23 Mar 2010 18:22
You haven't said which recommendations from here you've tried, but try
changing h:mm to [h]:mm
--
David Biddulph


"Rhonda Urbanczyk" <Rhonda Urbanczyk(a)discussions.microsoft.com> wrote in
message news:2EEB6CEA-17AA-405B-9BC3-7FED1744E2C5(a)microsoft.com...
> 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
>

From: Rhonda Urbanczyk on 23 Mar 2010 18:41
Thank you both so much, perfect!
 | 
Pages: 1
Prev: Indirect and Sheet Name
Next: VLookup with Search for in String