| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help Please
I need some help working with times. I need to be able to add up times worked for 12 months of the year. For example if one workd 49 hours and 23 minutes the month of Jan and the same for Feb, how do I do this and keep a running sum of them? I can't see to figure out how to format it so that it does not change to time of day since it will be over 24 hours. Thanks. -- jlogan21 ------------------------------------------------------------------------ jlogan21's Profile: http://www.excelforum.com/member.php...o&userid=30111 View this thread: http://www.excelforum.com/showthread...hreadid=506029 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need Help Please
Hi
The cell holding the cumulative time needs to be formatted as [hh]:mm FormatCellsNumberCustom [hh]:mm -- Regards Roger Govier "jlogan21" wrote in message ... I need some help working with times. I need to be able to add up times worked for 12 months of the year. For example if one workd 49 hours and 23 minutes the month of Jan and the same for Feb, how do I do this and keep a running sum of them? I can't see to figure out how to format it so that it does not change to time of day since it will be over 24 hours. Thanks. -- jlogan21 ------------------------------------------------------------------------ jlogan21's Profile: http://www.excelforum.com/member.php...o&userid=30111 View this thread: http://www.excelforum.com/showthread...hreadid=506029 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need Help Please
Ok I tried that and this is what happend. For the month of Jan. I have total hours of 146 hours and 23 minutes. When I formatted the cell it turned it into 3509:31? -- jlogan21 ------------------------------------------------------------------------ jlogan21's Profile: http://www.excelforum.com/member.php...o&userid=30111 View this thread: http://www.excelforum.com/showthread...hreadid=506029 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need Help Please
Hi
What is the formula you are using? What does the data look like in the source cells being summed? -- Regards Roger Govier "jlogan21" wrote in message ... Ok I tried that and this is what happend. For the month of Jan. I have total hours of 146 hours and 23 minutes. When I formatted the cell it turned it into 3509:31? -- jlogan21 ------------------------------------------------------------------------ jlogan21's Profile: http://www.excelforum.com/member.php...o&userid=30111 View this thread: http://www.excelforum.com/showthread...hreadid=506029 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need Help Please
I am just using the =SUM(A1:A10). But can't seem to figure out how to format the cells so that it will add the times correctly. I just dont know why it is changing the numbers the way that it is. Thanks Jennifer -- jlogan21 ------------------------------------------------------------------------ jlogan21's Profile: http://www.excelforum.com/member.php...o&userid=30111 View this thread: http://www.excelforum.com/showthread...hreadid=506029 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need Help Please
Hi Jennifer
What is in cells A1:A10? How are those cells formatted? -- Regards Roger Govier "jlogan21" wrote in message ... I am just using the =SUM(A1:A10). But can't seem to figure out how to format the cells so that it will add the times correctly. I just dont know why it is changing the numbers the way that it is. Thanks Jennifer -- jlogan21 ------------------------------------------------------------------------ jlogan21's Profile: http://www.excelforum.com/member.php...o&userid=30111 View this thread: http://www.excelforum.com/showthread...hreadid=506029 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need Help Please
Each of those cells contains the total hours worked for the month. The example I was using was that Jan. has a total number of hours worked at 146 hours and 23 minutes. I am trying to do a year to date total in another celll, that will keep a total of all hours worked each month. At the moment I do not have any formatting as I cant figure out how it is supposed to be done so that it will add the hours and minutes correctly to keep the running total. Ultimate goal is to have a total time worked for the year. Thanks Jennifer -- jlogan21 ------------------------------------------------------------------------ jlogan21's Profile: http://www.excelforum.com/member.php...o&userid=30111 View this thread: http://www.excelforum.com/showthread...hreadid=506029 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
