Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding columns of times
I'm trying to add increments of time (in the h:mm format, for example 3:15),
to come up with the total hours and minutes in part of a column, in Excel 2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and neither works properly. I've tried adjusting the format of the cell with the formula in it. Still not working. Can anyone help? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding columns of times
Format cells as [h]:mm and the SUM as normal.
"hadleigh" wrote: I'm trying to add increments of time (in the h:mm format, for example 3:15), to come up with the total hours and minutes in part of a column, in Excel 2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and neither works properly. I've tried adjusting the format of the cell with the formula in it. Still not working. Can anyone help? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding columns of times
Format the result cell as:
[hh]:mm 03:15 12:40 07:35 06:10 29:40 Regards Trevor "hadleigh" wrote in message ... I'm trying to add increments of time (in the h:mm format, for example 3:15), to come up with the total hours and minutes in part of a column, in Excel 2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and neither works properly. I've tried adjusting the format of the cell with the formula in it. Still not working. Can anyone help? Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding columns of times
Sorry to be dense, but I'm something of an Excel novice and I don't
understand this. Do you mean to go into the Format/Cell command, and then choose Time and then the 13:30 format? Because that didn't seem to work. Or, do I add [hh]:mm into the formula for the cell? I've tried that and it's not working but perhaps I'm not doing it right. Could you spell out the right formula? Is it =SUM(cell:cell)*24[hh]:mm? Many thanks for the response! "Trevor Shuttleworth" wrote: Format the result cell as: [hh]:mm 03:15 12:40 07:35 06:10 29:40 Regards Trevor "hadleigh" wrote in message ... I'm trying to add increments of time (in the h:mm format, for example 3:15), to come up with the total hours and minutes in part of a column, in Excel 2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and neither works properly. I've tried adjusting the format of the cell with the formula in it. Still not working. Can anyone help? Thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding columns of times
Use Format | Cells... | Custom | Type: [hh]:mm
Regards Trevor "hadleigh" wrote in message ... Sorry to be dense, but I'm something of an Excel novice and I don't understand this. Do you mean to go into the Format/Cell command, and then choose Time and then the 13:30 format? Because that didn't seem to work. Or, do I add [hh]:mm into the formula for the cell? I've tried that and it's not working but perhaps I'm not doing it right. Could you spell out the right formula? Is it =SUM(cell:cell)*24[hh]:mm? Many thanks for the response! "Trevor Shuttleworth" wrote: Format the result cell as: [hh]:mm 03:15 12:40 07:35 06:10 29:40 Regards Trevor "hadleigh" wrote in message ... I'm trying to add increments of time (in the h:mm format, for example 3:15), to come up with the total hours and minutes in part of a column, in Excel 2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and neither works properly. I've tried adjusting the format of the cell with the formula in it. Still not working. Can anyone help? Thanks. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding columns of times
Trevor,
Thanks very much for the response. This is working fine now as long as the total hours don't equal more than 24. The sum isn't right if the total is more than 24 hours (even when I add *24 to the formula) but at least it's working right in the other cases. Regards, Hadleigh "Trevor Shuttleworth" wrote: Use Format | Cells... | Custom | Type: [hh]:mm Regards Trevor "hadleigh" wrote in message ... Sorry to be dense, but I'm something of an Excel novice and I don't understand this. Do you mean to go into the Format/Cell command, and then choose Time and then the 13:30 format? Because that didn't seem to work. Or, do I add [hh]:mm into the formula for the cell? I've tried that and it's not working but perhaps I'm not doing it right. Could you spell out the right formula? Is it =SUM(cell:cell)*24[hh]:mm? Many thanks for the response! "Trevor Shuttleworth" wrote: Format the result cell as: [hh]:mm 03:15 12:40 07:35 06:10 29:40 Regards Trevor "hadleigh" wrote in message ... I'm trying to add increments of time (in the h:mm format, for example 3:15), to come up with the total hours and minutes in part of a column, in Excel 2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and neither works properly. I've tried adjusting the format of the cell with the formula in it. Still not working. Can anyone help? Thanks. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding columns of times
The point of the square brackets ([]) around the hh thus[hh] is
to cater for more than 24 hours. You should be able to accumulate hundreds of hours. 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 24:00 25:00 259:00 all formatted as [hh]:mm Regards Trevor "hadleigh" wrote in message ... Trevor, Thanks very much for the response. This is working fine now as long as the total hours don't equal more than 24. The sum isn't right if the total is more than 24 hours (even when I add *24 to the formula) but at least it's working right in the other cases. Regards, Hadleigh "Trevor Shuttleworth" wrote: Use Format | Cells... | Custom | Type: [hh]:mm Regards Trevor "hadleigh" wrote in message ... Sorry to be dense, but I'm something of an Excel novice and I don't understand this. Do you mean to go into the Format/Cell command, and then choose Time and then the 13:30 format? Because that didn't seem to work. Or, do I add [hh]:mm into the formula for the cell? I've tried that and it's not working but perhaps I'm not doing it right. Could you spell out the right formula? Is it =SUM(cell:cell)*24[hh]:mm? Many thanks for the response! "Trevor Shuttleworth" wrote: Format the result cell as: [hh]:mm 03:15 12:40 07:35 06:10 29:40 Regards Trevor "hadleigh" wrote in message ... I'm trying to add increments of time (in the h:mm format, for example 3:15), to come up with the total hours and minutes in part of a column, in Excel 2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and neither works properly. I've tried adjusting the format of the cell with the formula in it. Still not working. Can anyone help? Thanks. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding columns of times
NOW I get it. I thought I had to select [hh]:mm which wasn't an option under
the Type column when I was formatting the cell. So I was using the closest thing, which was h:mm. Now I realize I can type in my own entry, so I typed in [hh]:mm and it worked like a charm. THANK YOU SO MUCH!! "Trevor Shuttleworth" wrote: The point of the square brackets ([]) around the hh thus[hh] is to cater for more than 24 hours. You should be able to accumulate hundreds of hours. 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 24:00 25:00 259:00 all formatted as [hh]:mm Regards Trevor "hadleigh" wrote in message ... Trevor, Thanks very much for the response. This is working fine now as long as the total hours don't equal more than 24. The sum isn't right if the total is more than 24 hours (even when I add *24 to the formula) but at least it's working right in the other cases. Regards, Hadleigh "Trevor Shuttleworth" wrote: Use Format | Cells... | Custom | Type: [hh]:mm Regards Trevor "hadleigh" wrote in message ... Sorry to be dense, but I'm something of an Excel novice and I don't understand this. Do you mean to go into the Format/Cell command, and then choose Time and then the 13:30 format? Because that didn't seem to work. Or, do I add [hh]:mm into the formula for the cell? I've tried that and it's not working but perhaps I'm not doing it right. Could you spell out the right formula? Is it =SUM(cell:cell)*24[hh]:mm? Many thanks for the response! "Trevor Shuttleworth" wrote: Format the result cell as: [hh]:mm 03:15 12:40 07:35 06:10 29:40 Regards Trevor "hadleigh" wrote in message ... I'm trying to add increments of time (in the h:mm format, for example 3:15), to come up with the total hours and minutes in part of a column, in Excel 2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and neither works properly. I've tried adjusting the format of the cell with the formula in it. Still not working. Can anyone help? Thanks. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding columns of times
You are very welcome.
Regards Trevor "hadleigh" wrote in message ... NOW I get it. I thought I had to select [hh]:mm which wasn't an option under the Type column when I was formatting the cell. So I was using the closest thing, which was h:mm. Now I realize I can type in my own entry, so I typed in [hh]:mm and it worked like a charm. THANK YOU SO MUCH!! "Trevor Shuttleworth" wrote: The point of the square brackets ([]) around the hh thus[hh] is to cater for more than 24 hours. You should be able to accumulate hundreds of hours. 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 24:00 25:00 259:00 all formatted as [hh]:mm Regards Trevor "hadleigh" wrote in message ... Trevor, Thanks very much for the response. This is working fine now as long as the total hours don't equal more than 24. The sum isn't right if the total is more than 24 hours (even when I add *24 to the formula) but at least it's working right in the other cases. Regards, Hadleigh "Trevor Shuttleworth" wrote: Use Format | Cells... | Custom | Type: [hh]:mm Regards Trevor "hadleigh" wrote in message ... Sorry to be dense, but I'm something of an Excel novice and I don't understand this. Do you mean to go into the Format/Cell command, and then choose Time and then the 13:30 format? Because that didn't seem to work. Or, do I add [hh]:mm into the formula for the cell? I've tried that and it's not working but perhaps I'm not doing it right. Could you spell out the right formula? Is it =SUM(cell:cell)*24[hh]:mm? Many thanks for the response! "Trevor Shuttleworth" wrote: Format the result cell as: [hh]:mm 03:15 12:40 07:35 06:10 29:40 Regards Trevor "hadleigh" wrote in message ... I'm trying to add increments of time (in the h:mm format, for example 3:15), to come up with the total hours and minutes in part of a column, in Excel 2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and neither works properly. I've tried adjusting the format of the cell with the formula in it. Still not working. Can anyone help? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding columns in Pivot Table having common description | Excel Worksheet Functions | |||
adding three consecutive columns | Excel Worksheet Functions | |||
Pivot Table for 3 columns of elapsed times | Excel Discussion (Misc queries) | |||
Adding Times | Excel Worksheet Functions | |||
Adding quotes to columns | Excel Discussion (Misc queries) |