How to change time span to decimal format in Excel?

Question

I have the following problem. In my excel sheet, I subtracted two time values ​​to get its time interval. Here is an example:

16:30-8:00=8:30

the cell format is time, so everything is in order. Now the problem: I need to show the time span as well as decimal. So, 8:30should 8,50 anyone know how to do this?

Answer 1

Use =24*(B2-C2)where the cell in which the calculation is to be formatted in 2 decimal format.

B2 = start time.

C2 = end time.

Answer 2

try it

A3 08:30, A4

=HOUR(A3) & TEXT(MINUTE(A3)/60, ".00")