Summing hours - not by 24 hour format

Matty2470 · Apr 18th, 2002, 08:29 AM

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 · Apr 18th, 2002, 08:46 AM

Quote:

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

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

Visions_Fugitive · Apr 18th, 2002, 08:54 AM

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:

Code:

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

Apr 18th, 2002, 08:54 AM	#3
Visions_Fugitive New Member Join Date: Apr 2002 Location: Milwaukee, WI Posts: 18	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: Code: =SUM(DAY(A2)24,DAY(A3)24,HOUR(A2),HOUR(A3),MINUTE(A2)/60,MINUTE(A3)/60)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 08:29 AM	#1
Matty2470 New Member Join Date: Mar 2002 Posts: 24	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