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 , "Shiblie Bshara" 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
