My task is very simple but I cannot figure out how to do it.
I am setting up a time sheet in OpenOffice Calc with 3 columns. The first two columns are Time formatted columns that represent my start and end time. I want the third column to show the difference in hours as a decimal. For example, this is my desired display:
| 9:00 AM | 12:30 PM | 3.5 Hrs |
I think I need a combination of a function and formatting, but I just can't make it work.