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.