P
Pastor Selma
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.
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.