G
Guest
I am having a problem with calculating time in excel. I have a work sheet
that tracks how many hours each person has per day then gives a total of
hours at the end of the week. Here is the problem-when it reaches 60 mins it
doesn't add another hour. Exampel: 7.27 hours + 3.30 hours + 8.15 hours +
3.00 hours + 5.22 hours = 26.94 this should read 27.34. so the question is
how do i get excel to round it to the correct hour/min reading. I am unsing
excel 2000
that tracks how many hours each person has per day then gives a total of
hours at the end of the week. Here is the problem-when it reaches 60 mins it
doesn't add another hour. Exampel: 7.27 hours + 3.30 hours + 8.15 hours +
3.00 hours + 5.22 hours = 26.94 this should read 27.34. so the question is
how do i get excel to round it to the correct hour/min reading. I am unsing
excel 2000