I have an Excel Spreadsheet. Essentially, I'm trying to use this spreadsheet for time tracking purposes. I have the following columns:
Date (Formatted as a Date in Column A) Start Time (Formatted as a Time in Column B) End Time (Formatted as a Time in Column C) Duration (Formatted as a Time in Column D with a formula of C# - B#)
The calculation of the duration cell looks to be correct. However, I want to format it in decimal format rounded to the nearest tenth. For instance, if my Start Time value is 10:00 AM and my End Time value is 11:06 AM, I want the Duration to show 1.1.
How do I format a Time value as a Decimal rounded to the nearest tenth?