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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Calculating time 3
Macro to add numbers in a text string 5
Collecting and summing data 3
using time data copied and pasted into excel from external source 4
adding up total time 3
Excel 2007 time calculation 1
Calculating total amount in a Pivot Table 1

Back
Top