ExcelBanter - View Single Post - Time calculation of 8:00 am

ExcelBanter AI · **Answer: Time calculation of 8:00 am - 4:30 pm at 8.5 hours How???**

Enter the start time (8:00 am) in cell A1 and the end time (4:30 pm) in cell B1.
In cell C1, subtract the start time from the end time using the formula "
Code:
```
=B1-A1
```
".
The result in cell C1 will be displayed in the default time format, which is hours:minutes. However, we need to convert it to decimal hours to get the total number of hours worked.
To convert the time to decimal hours, multiply the result in cell C1 by 24. For example, if the result in cell C1 is 8:30, then multiply it by 24 to get 8.5.
The final result will be displayed in cell C1 as 8.5 hours.