| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
surely it cannot be that difficult...
......can it!!
Column of cells J12 to J42 inclusive. Each cell has an amount of hours and minutes worked laid out like eg. 07:27 or 11:57 All I need to do is add the hours and minutes up!!! The answer is looking me in the face, and I can not see it! HELP....please :-) Best regards Bob |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
surely it cannot be that difficult...
=sum(j12:j42)
give it a nice custom format of: [hh]:mm:ss Bob Holdford wrote: .....can it!! Column of cells J12 to J42 inclusive. Each cell has an amount of hours and minutes worked laid out like eg. 07:27 or 11:57 All I need to do is add the hours and minutes up!!! The answer is looking me in the face, and I can not see it! HELP....please :-) Best regards Bob -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
surely it cannot be that difficult...
Thanks Dave.
Yep, I thought of that. Tried it out.....no joy. Works fine on a new sheet!! I think the problem maybe the formula already in the cells where the times are. My head really hurts now :-( Cheers Bob "Dave Peterson" wrote in message ... =sum(j12:j42) give it a nice custom format of: [hh]:mm:ss Bob Holdford wrote: .....can it!! Column of cells J12 to J42 inclusive. Each cell has an amount of hours and minutes worked laid out like eg. 07:27 or 11:57 All I need to do is add the hours and minutes up!!! The answer is looking me in the face, and I can not see it! HELP....please :-) Best regards Bob -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
surely it cannot be that difficult...
My guess is that the cells that look like times are really text (not numbers).
Try selectinging an empty cell edit|copy select the range with the times edit|paste special|check add and values (maybe re-apply a nice time format to that range) Now look at the cell with =sum() in it. Bob Holdford wrote: Thanks Dave. Yep, I thought of that. Tried it out.....no joy. Works fine on a new sheet!! I think the problem maybe the formula already in the cells where the times are. My head really hurts now :-( Cheers Bob "Dave Peterson" wrote in message ... =sum(j12:j42) give it a nice custom format of: [hh]:mm:ss Bob Holdford wrote: .....can it!! Column of cells J12 to J42 inclusive. Each cell has an amount of hours and minutes worked laid out like eg. 07:27 or 11:57 All I need to do is add the hours and minutes up!!! The answer is looking me in the face, and I can not see it! HELP....please :-) Best regards Bob -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
surely it cannot be that difficult...
Nope!! Well, I am thick, but could not get that to work.
Format Cells, suggests 'Custom' & 'hh:mm'. Possibly be much easier if I stopped thinking :-) "Dave Peterson" wrote in message ... My guess is that the cells that look like times are really text (not numbers). Try selectinging an empty cell edit|copy select the range with the times edit|paste special|check add and values (maybe re-apply a nice time format to that range) Now look at the cell with =sum() in it. Bob Holdford wrote: Thanks Dave. Yep, I thought of that. Tried it out.....no joy. Works fine on a new sheet!! I think the problem maybe the formula already in the cells where the times are. My head really hurts now :-( Cheers Bob "Dave Peterson" wrote in message ... =sum(j12:j42) give it a nice custom format of: [hh]:mm:ss Bob Holdford wrote: .....can it!! Column of cells J12 to J42 inclusive. Each cell has an amount of hours and minutes worked laid out like eg. 07:27 or 11:57 All I need to do is add the hours and minutes up!!! The answer is looking me in the face, and I can not see it! HELP....please :-) Best regards Bob -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
surely it cannot be that difficult...
If all you did was change the format, then that isn't enough to change the
values in the cell. You may want to show a few examples of what's in that range (formulas and values) and what the formula evaluated to. Without more information, I'm out of guesses. Bob Holdford wrote: Nope!! Well, I am thick, but could not get that to work. Format Cells, suggests 'Custom' & 'hh:mm'. Possibly be much easier if I stopped thinking :-) "Dave Peterson" wrote in message ... My guess is that the cells that look like times are really text (not numbers). Try selectinging an empty cell edit|copy select the range with the times edit|paste special|check add and values (maybe re-apply a nice time format to that range) Now look at the cell with =sum() in it. Bob Holdford wrote: Thanks Dave. Yep, I thought of that. Tried it out.....no joy. Works fine on a new sheet!! I think the problem maybe the formula already in the cells where the times are. My head really hurts now :-( Cheers Bob "Dave Peterson" wrote in message ... =sum(j12:j42) give it a nice custom format of: [hh]:mm:ss Bob Holdford wrote: .....can it!! Column of cells J12 to J42 inclusive. Each cell has an amount of hours and minutes worked laid out like eg. 07:27 or 11:57 All I need to do is add the hours and minutes up!!! The answer is looking me in the face, and I can not see it! HELP....please :-) Best regards Bob -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
surely it cannot be that difficult...
You may want to show a few examples of what's in that range (formulas and
values) and what the =SUM() formula evaluated to. Dave Peterson wrote: If all you did was change the format, then that isn't enough to change the values in the cell. You may want to show a few examples of what's in that range (formulas and values) and what the formula evaluated to. Without more information, I'm out of guesses. Bob Holdford wrote: Nope!! Well, I am thick, but could not get that to work. Format Cells, suggests 'Custom' & 'hh:mm'. Possibly be much easier if I stopped thinking :-) "Dave Peterson" wrote in message ... My guess is that the cells that look like times are really text (not numbers). Try selectinging an empty cell edit|copy select the range with the times edit|paste special|check add and values (maybe re-apply a nice time format to that range) Now look at the cell with =sum() in it. Bob Holdford wrote: Thanks Dave. Yep, I thought of that. Tried it out.....no joy. Works fine on a new sheet!! I think the problem maybe the formula already in the cells where the times are. My head really hurts now :-( Cheers Bob "Dave Peterson" wrote in message ... =sum(j12:j42) give it a nice custom format of: [hh]:mm:ss Bob Holdford wrote: .....can it!! Column of cells J12 to J42 inclusive. Each cell has an amount of hours and minutes worked laid out like eg. 07:27 or 11:57 All I need to do is add the hours and minutes up!!! The answer is looking me in the face, and I can not see it! HELP....please :-) Best regards Bob -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difficult for me, probably basic to you | Excel Worksheet Functions | |||
| Help, too difficult for me. | Excel Worksheet Functions | |||
| Too difficult for me, please help. | Excel Worksheet Functions | |||
| Difficult but do-able? | Excel Discussion (Misc queries) | |||
| Surely a simple solution exists | Excel Worksheet Functions | |||
Linear Mode
