Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ADD TIME DURATION
Hi, I copied & pasted data from a report onto an Excel Spreadsheet. I wish
to total a time duration column. The data is in the form 0:00:15 (15 seconds) or 0:13:50 (13 minutes, 50 seconds). Heres the trouble... I cannot add these! I keep getting a total of 0:00:00. I have tried copying, then hitting paste special and pasting the 'values', but to no avail. I have ties various random formatting techniques, but again, to no avail. Funny thing is, if I manually type the values, I can add. I would like to avoid this as there are 100's of values... hopefully, someone has encountered this before and can be of assistance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ADD TIME DURATION
Hi,
Try formatting all the cells to [h]:mm:ss including the total cell. -- Cheers, Shane Devenshire "Dan" wrote: Hi, I copied & pasted data from a report onto an Excel Spreadsheet. I wish to total a time duration column. The data is in the form 0:00:15 (15 seconds) or 0:13:50 (13 minutes, 50 seconds). Heres the trouble... I cannot add these! I keep getting a total of 0:00:00. I have tried copying, then hitting paste special and pasting the 'values', but to no avail. I have ties various random formatting techniques, but again, to no avail. Funny thing is, if I manually type the values, I can add. I would like to avoid this as there are 100's of values... hopefully, someone has encountered this before and can be of assistance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
ADD TIME DURATION
My guess would be that you haven't actually got Excel times (numbers) in
those cells, but instead you've got text that looks vaguely like times. You can get a clue by trying to change the time formatting temporarily, and see whether it changes. If it doesn't change to your new format, it's probably text. Another way of checking is with the ISTEXT and ISNUMBER functions. It may be as simple as having spaces before and/ or after your time. You might be able to solve it by =--TRIM(A2) and formatting the resultant cell appropriately. -- David Biddulph "Dan" wrote in message ... Hi, I copied & pasted data from a report onto an Excel Spreadsheet. I wish to total a time duration column. The data is in the form 0:00:15 (15 seconds) or 0:13:50 (13 minutes, 50 seconds). Heres the trouble... I cannot add these! I keep getting a total of 0:00:00. I have tried copying, then hitting paste special and pasting the 'values', but to no avail. I have ties various random formatting techniques, but again, to no avail. Funny thing is, if I manually type the values, I can add. I would like to avoid this as there are 100's of values... hopefully, someone has encountered this before and can be of assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add duration to start time | Excel Worksheet Functions | |||
Date/time Duration | Excel Worksheet Functions | |||
Time duration formula | Excel Discussion (Misc queries) | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) | |||
How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o. | Excel Worksheet Functions |