Hi, I'm a little puzzled about how to calculate time in
timetracking system. I want to report on the amount of
time spent on different projects.

1) I format a cell with [h]:mm, and enter 1:00, for one
hour spent on a project. The formula bar says the entry is
1:00:00 AM. This is not what I am expecting.

2) I need to convert the total time spent into days. If I
have two cells with 8:00 hours and one with 7:00 hours, it
should be 2 days, 7 hours. With the formula =(A1:A5)/8 the
result shows 2:52.

Anyone have any ideas how to manage this? Thanks in
advance.......Herb