Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change range for dynamic chart in excel 2000 with button? | Charts and Charting in Excel | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
How do I merge in a selected range of cells out of Excel? | Excel Discussion (Misc queries) | |||
Specify a null value in an Excel Database criteria range | Excel Worksheet Functions | |||
How do I duplicate a sheet 20 times in an excel spreadsheet | Excel Worksheet Functions |