I have two time-formatted cells and I need to calculate the difference (e.g., 2.75) in hours between the two.10:30 AM   |   1:15 PMSimply =B1-A1will not do the trick.
How to calculate difference in hours between two time fields
google spreadsheets
I would use the following formula to calculate the difference in hours.Formula=(B1-A1)*24ExplainedThe time difference is calculated in days. If you multiply times 24, you end up with hours. Time difference is 2 hours and 3 quarters of an hour (165 min).ScreenshotExampleI've prepared an example file for you: Time Tracker formula and included your own solution in C1.