View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pastor Selma Pastor Selma is offline
external usenet poster
 
Posts: 1
Default Calculating time

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