View Single Post
  #4   Report Post  
Krishna
 
Posts: n/a
Default



"Peo Sjoblom" wrote:

What's your question? If you know that 1 is 24 hours in Excel it is easy to
add and subtract different times


Perhaps I didn't make myself very clear.

Consider the following numbers:

Task 1 0:30
Task 2 0:45
Task 3 10:30
Task 4 1:20
Task 5 2:25
Task 6 0:45
Task 7 1:30
Task 8 3:30
Task 9 4:45
Task 10 5:45

If I want to sum up the time for all the tasks, by sum(...), I get 7:45 as
the result, which 31:45 (the correct total), minus 24 hours.

What I want is to get away from this baggage of 24 hours.

Thank you for the reply.