Convert cell containing time to number

[tigerdel]

I have cells that contain sums of time and I need them to show as 00.00 and not hh.mm

The problem occurs when I have a sum of hours over 24 [for instance the sum of hours for an employee = 50:00 shows as 2.08 if I was to customise to a number]

I know I can do it by adding another cell an converting the hours to numbers but I was wondering if there was a simple way of doing it without having to add additional columns for these formulas and simply for the cell to calculate the hours and then convert it to a number

Thanks for looking

 

[Rick Rothstein]

I have cells that contain sums of time and I need them to show as 00.00 and not hh.mm

The problem occurs when I have a sum of hours over 24 [for instance the sum of hours for an employee = 50:00 shows as 2.08 if I was to customise to a number]

I am having trouble figuring out what you want. What exactly does "I need them to show as 00.00 and not hh.mm" mean. Your example of =50:00 shows as 2.08 is confusing as well... where did the .08 come from. Can you describe, in detail, using an actual example (don't make it an even number of hours), how you are converting your hours to numbers?

 

[footoo]

Try formatting as [hh]:mm

 

[tigerdel]

Thanks all - Issue solved