nparsons75
Wellknown Member
 Joined
 Sep 23, 2013
 Messages
 1,247
 Office Version

 2016
Hi,
I am trying to calculate times but seem to have an anomaly I am hoping someone can assist with. Please see the table below. From 14:15:00 to 22:30:00 should equate to 8 hours and 15 minutes. However, when I total the hours column I get 7.917 hours?? Why would this be, appreciate any help.
<tbody>
</tbody>
Thanks
I am trying to calculate times but seem to have an anomaly I am hoping someone can assist with. Please see the table below. From 14:15:00 to 22:30:00 should equate to 8 hours and 15 minutes. However, when I total the hours column I get 7.917 hours?? Why would this be, appreciate any help.
start  end  hours 
14:15:00  14:30:00  0.250 
14:30:00  18:00:00  3.500 
18:20:00  22:30:00  4.167 
<tbody>
</tbody>
Thanks