Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula for adding up sub-totals in time format
I'm having trouble adding up all the sub-totals in my timesheet.
I have a number of sub-totals in h:mm format for each week of the month. I used the AutoSum function to calculate each of these weekly sub-totals. When I try to calculate my total hours for the month (i.e. add up all the weekly sub-totals), I use the forumla: =SUM(C20,C35,C50,C57) . However, Excel fails to add these up correctly - it simply reproduces the sub-total figure at C20. I've checked the fx field and the formula appears correctly. I've also made sure all the time cells are in the same h:mm format. Can anyone help me?! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula for adding up sub-totals in time format
Hi,
If the total exceeds 24hrs you need a format of [hh]:mm Mike "Nick T" wrote: I'm having trouble adding up all the sub-totals in my timesheet. I have a number of sub-totals in h:mm format for each week of the month. I used the AutoSum function to calculate each of these weekly sub-totals. When I try to calculate my total hours for the month (i.e. add up all the weekly sub-totals), I use the forumla: =SUM(C20,C35,C50,C57) . However, Excel fails to add these up correctly - it simply reproduces the sub-total figure at C20. I've checked the fx field and the formula appears correctly. I've also made sure all the time cells are in the same h:mm format. Can anyone help me?! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula for adding up sub-totals in time format
Thank you Mike! Yes, the total does exceed 24 hours. I changed the format as
you suggested, and everything works perfectly now. I'm very grateful for your help. :-) Kind regards, Nick in Sydney, Australia "Mike H" wrote: Hi, If the total exceeds 24hrs you need a format of [hh]:mm Mike "Nick T" wrote: I'm having trouble adding up all the sub-totals in my timesheet. I have a number of sub-totals in h:mm format for each week of the month. I used the AutoSum function to calculate each of these weekly sub-totals. When I try to calculate my total hours for the month (i.e. add up all the weekly sub-totals), I use the forumla: =SUM(C20,C35,C50,C57) . However, Excel fails to add these up correctly - it simply reproduces the sub-total figure at C20. I've checked the fx field and the formula appears correctly. I've also made sure all the time cells are in the same h:mm format. Can anyone help me?! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding up time function totals | Excel Worksheet Functions | |||
Formula for adding up totals of groups | Excel Discussion (Misc queries) | |||
Adding Time Format | Excel Discussion (Misc queries) | |||
Formula for adding totals from separate worksheets | Excel Discussion (Misc queries) | |||
Formula for adding several worksheet totals | Excel Discussion (Misc queries) |