Summing hours - not by 24 hour format

[Matty2470]

Hi

I want to sum up hours and have the hours calculate to the total with out them bein rounded up to the nearest 24 hours.

What am I missing?

Thank you

 

[IML]

On 2002-04-18 07:29, Matty2470 wrote:
What am I missing?

Not sure, could you provide a bit of a sample?

 

[Visions_Fugitive]

Use DAY, HOUR, and MINUTE to sum your time values in numeric format. If you're summing time values in A2 and A3, use this:

=SUM(DAY(A2)*24,DAY(A3)*24,HOUR(A2),HOUR(A3),MINUTE(A2)/60,MINUTE(A3)/60)