ExcelBanter - Adding Time Format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Adding Time Format (https://www.excelbanter.com/excel-discussion-misc-queries/53211-adding-time-format.html)

jtinne

Adding Time Format

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.

All times are GMT +1. The time now is 02:26 PM.