Convert HH:MM time to decimal

[Olivier Goossens Bara]

Hello

I think that I have a very common problem but I do not find easy solution

I want to use a Worksheet as a time sheet to compute remuneration

I have a Start and an End column in time format HH:MM 00:00 to 24:00
I want to get the elapsed time as a decimal value. So start=8:00 end=9:45
should give a decimal delta of 1,75

How is it possible ?

 

[Laura Cook]

With start time in A1 and end time in B1:

=(B1-A1)*24

Format as number.