How do i get excel to add a range of times & display as total as .
 

Hi
I'm trying to get excel to add a range of times together and display the
total as the sum of all of these hours. I can enter the times but keep
getting the strangest of totals. Any help please.

Use a custom format [hh]:mm for example otherwise it will always start over
after 24 hours so 30:00 shows as 06:00, later if you need to apply a pay rate
note that you have to convert to decimals by multiplying with 24, i.e.

=time*24*payrate

Regards,

Peo Sjoblom

"pm_faery" wrote:

Hi
I'm trying to get excel to add a range of times together and display the
total as the sum of all of these hours. I can enter the times but keep
getting the strangest of totals. Any help please.

Check out the info on dates and times arithmetic on Chip Pearson's site.

http://www.cpearson.com/excel/datetime.htm#AddingTimes


Gord Dibben Excel MVP

On Tue, 10 May 2005 09:21:13 -0700, "pm_faery"
wrote:

Hi
I'm trying to get excel to add a range of times together and display the
total as the sum of all of these hours. I can enter the times but keep
getting the strangest of totals. Any help please.