Help Wanted

Dear All,

I need an automatic formula or a format that give's me the ability to enter
these numbers (Handling Time) as (HH:MM)
but to be converted to fractions (example: 00:30 should be displayed as
0.50, as 00:30 is 50% of an hour)
at the same time,


Every Day is 10 houres




text text HH:MM
HH:MM DD
Case Handled by handling time (##.##)
Ageing (##:##) Total handling Time(DD)
=========================================================================================
Case 1 John 23:15
23:15 = 23.25 02
(want it to be
displayed as 23.25) (want it to be displayed as 23.25)
_____________________________________________________________________________________
Sara 48:55 = 48.91
72.10 = 72.16 07
***********************************************************************************************************************************
Case 2 George 01:10 = 1.16
01:10 = 1.16 00
Clare 81:22= 1.36
82:32= 82.53 08
************************************************************************************************************************************

I really need this urgently, so please please please. help me with that.


Thanks in advance,
Best Regards,
Shiblie.B

Excel stores times as fractional days, so multiply by 24 hours per day:

A1: 0:30
B1: =A1*24 ===> 0.5


A2: 1:10
B2: =A2*24 ==> 1.171:10

(Format the B cells as General or Number).


In article <97722897-C554-4458-BBFA-3C7653960299 DeleteThis @microsoft.com>,
"Shiblie Bshara" <shb182 DeleteThis @hotmail.com> wrote:

> Dear All,
>
> I need an automatic formula or a format that give's me the ability to enter
> these numbers (Handling Time) as (HH:MM)
> but to be converted to fractions (example: 00:30 should be displayed as
> 0.50, as 00:30 is 50% of an hour)
> at the same time,
>
>
> Every Day is 10 houres
>
>
>
>
> text text HH:MM
> HH:MM DD
> Case Handled by handling time (##.##)
> Ageing (##:##) Total handling Time(DD)
> ==============================================================================
> ===========
> Case 1 John 23:15
> 23:15 = 23.25 02
> (want it to be
> displayed as 23.25) (want it to be displayed as 23.25)
> ______________________________________________________________________________
> _______
> Sara 48:55 = 48.91
> 72.10 = 72.16 07
> ******************************************************************************
> *****************************************************
> Case 2 George 01:10 = 1.16
> 01:10 = 1.16 00
> Clare 81:22= 1.36
> 82:32= 82.53 08
> ******************************************************************************
> ******************************************************
>
> I really need this urgently, so please please please. help me with that.
>
>
> Thanks in advance,
> Best Regards,
> Shiblie.B