How to change a timespan into decimal format in excel?
excel
Solution
Use `=24*(B2-C2)`, where the cell where calculation happens should be formatted in 2 decimal number format .
B2= start time.
C2= End time.
Problem
I have the following problem. In my excel sheet, I subtracted two time values to get its timespan. Here is an example: ``` 16:30-8:00=8:30 ``` the cell format is a time so its all fine. Now the problem: I need to show the timespan also as a decimal. So the `8:30` should be a `8,50` Anybody know how to do this?