change time to a 100 base

hey guys

I need a formula to change the time in my time sheet from a 60 minute base to a 100.

so 7:30 should show 7.5
that's formula needs to be placed in the blue column

thank you

that might be easier then you expect...

just multiply by 24 for Cell D8 change the formula to

Formula:

Please Login or Register  to view this content.

also reformat the cell from time to eigher General of number