By multiplying the formula with 24 you are converting the result into
decimal hours, so 8.33 means 8 and 1/3 hours, or 8 hrs and 20 mins. If
you want it to be displayed as 8:20, then format the cell as time and
change the formula to:

=E26-D26

Hope this helps.

Pete

On Jan 15, 1:22*am, Pastor Selma
wrote:
Hello out there!

I have a simple time calcution in Excel and for some reason when the time
contains minutes to does not calculate right. *Here's an example.

Start Time *End Time *Total Hours
8:00 AM 4:20 PM 8.33

the calculation is =(E26-D26)*24

It should have come out to 8.20 but came out to 8.33. *Can someone help!

Thanks.
--
Selma