How to convert hours using 00:00 format into standalone numbers, for
example 08:30 = 8.5h so I could sum these numbers at the bottom to
learn how many hours are in total.. Please help

On 2 May, 10:37, Chris J Dixon <ch...@cdixon.me.uk> wrote:

> enter a custom format for the total as [h]:mm

great tip, thank you very much

But if you do want the hours as a decimal number, just multiply by 24
and format the cell as General or Number.

Hope this helps.

Pete

On May 2, 10:44*am, suddengunfire <dariusdir...@googlemail.com> wrote:
> On 2 May, 10:37, Chris J Dixon <ch...@cdixon.me.uk> wrote:
>
> > enter a custom format for the total as [h]:mm
>
> great tip, thank you very much