you need to do something like this

A1: 8:30 AM
A2: 12:00 PM
A3: =(A2-A1)*24

and then format A3 as a number.

"jtinne" wrote:

I am adding time for a day and would like the total to be returned in a
different format. If I needed the time between 8:30am and 12:00pm added up
it displays 3:30 as my total. How do I have it display 3.5 as the total?
Currently the total cell is formatted [hh]:mm. Thanks for the help.