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 |
Help Wanted
=A2*24 and format the result as Number or General, not as Time.
-- David Biddulph "Shiblie Bshara" wrote in message ... 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 |
All times are GMT +1. The time now is 02:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com