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

P

pm_faery

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.
 
P

Peo Sjoblom

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
 
Top