Formula for time

[joshuafournier]

Good morning,
I have a formula to give me a total time.

I enter start time in a2
End time in b2
And total time goes into c2

Since we use a 24 hour clock 2 hours 30 minutes looks like this. 2:30. I would like to change how it displays to read 2.5 is there a format or formula I can use for that. I have lots of available cells to work with. Thank you for your time

 

[Robert Mika]

Good morning,
I have a formula to give me a total time.

I enter start time in a2
End time in b2
And total time goes into c2

Since we use a 24 hour clock 2 hours 30 minutes looks like this. 2:30. I would like to change how it displays to read 2.5 is there a format or formula I can use for that. I have lots of available cells to work with. Thank you for your time

Multiply Time value by 24 and format as General/Number

 

[taurean]

With cell formatted as general:
=CONVERT((B1-A1),"day","hr")

 

[joshuafournier]

Works perfect thank you very much!!!